XQuery & T-Sql
Follow
Find
1.9K views | +0 today
 
Scooped by Tony Pierascenzi
onto XQuery & T-Sql
Scoop.it!

Merrill Aldrich : Execute T-SQL Across Listed Servers/Databases

Merrill Aldrich : Execute T-SQL Across Listed Servers/Databases | XQuery & T-Sql | Scoop.it
Here's a handy trick – if you have a SQL script, stored as a text file, and need to run it against an arbitrary list of different databases on different SQL Server instances, try a little PowerShell. There are a lot of ways to accomplish ...
more...
No comment yet.
XQuery & T-Sql
Interesting links on XQuery and T-SQL
Your new post is loading...
Your new post is loading...
Scooped by Tony Pierascenzi
Scoop.it!

TSQL Coding Style - Database Journal

TSQL Coding Style - Database Journal | XQuery & T-Sql | Scoop.it
TSQL Coding Style
Database Journal
When you write TSQL code what kind of coding style do you use? Do you have a consistent way to comment and format your code? Does your organization provide standards for how you must code your TSQL?
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

tsql - Does SQL Server place shared locks on scanned records ...

tsql - Does SQL Server place shared locks on scanned records ... | XQuery & T-Sql | Scoop.it
My question is: shouldn't the database engine place shared locks on all the rows it read to ensure REPEATABLE READ ? What if some other transaction updates a record so that it would match with my WHERE clause in the ...
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

Alternative to XPath as Constants | QuickInnovations

Alternative to XPath as Constants | QuickInnovations | XQuery & T-Sql | Scoop.it
Now-a-days, XQuery and XPath are used heavily in all applications as XML has become a standard for data exchange in most of the applications. The modularization phase in any application development creates a need to ...
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

SQL Server - XML Examples(Xpath,Xquery,XML DML,XML Index ...

SQL Server - XML Examples(Xpath,Xquery,XML DML,XML Index ... | XQuery & T-Sql | Scoop.it
SQL Server - XML Examples(Xpath,Xquery,XML DML,XML Index,XML Schema). Example 1: Mostly we need XML in this format,i.e column names with their values enclosed within their column name tag. Consider below XML ...
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

Use PowerShell to Work with SQL Server Instance-Level Properties ...

Use PowerShell to Work with SQL Server Instance-Level Properties ... | XQuery & T-Sql | Scoop.it
The Hey, Scripting Guy! Blog includes helpful how-to posts and scripts about PowerShell, Active Directory, Exchange, SQL Server, VBScript and other Microsoft technologies.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

Indexing Wide Keys in SQL Server | Brent Ozar Unlimited

Indexing Wide Keys in SQL Server | Brent Ozar Unlimited | XQuery & T-Sql | Scoop.it
Key length matters in SQL Server indexes. It's a best practice to keep your index keys as narrow as possible, and SQL Server enforces a maximum key length of.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

SQL SERVER – T-SQL Script to Keep CPU Busy | SQL Server ...

SQL SERVER – T-SQL Script to Keep CPU Busy | SQL Server ... | XQuery & T-Sql | Scoop.it
SQL SERVER – T-SQL Script to Keep CPU Busy. February 22, 2013 by pinaldave. Never run this on your production server – you can just lose your job and can damage your organization. Now I am done with the disclaimer here is the subject ...
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

4 New T-SQL Functions - Visual Studio Magazine

4 New T-SQL Functions
Visual Studio Magazine
Every new version has delivered new functionality that should excite developers, and this release is no different. With the latest release of SQL Server, Microsoft produced 14 new T-SQL functions.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

Multiple Column Dynamic Sorting with T-SQL « Chris Tierney

I have done a bit of research to find the most efficient way to dynamically sort query results in Microsoft SQL Server 2008. I ran each query test twice, changing the “ORDER BY” clause. I would then check the query plan cache ...
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

SQL SERVER – How to Use Instead of Trigger – Guest Post by ...

SQL SERVER – How to Use Instead of Trigger – Guest Post by ... | XQuery & T-Sql | Scoop.it
A trigger is an exceptional sort of stored procedure which functions when we try to amend the data in a table like inserting, deleting or updating data. It is a database object, executed automatically and is bound to a table.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

Generating .NET POCO Classes for SQL Query Results - Visual Studio Magazine

Generating .NET POCO Classes for SQL Query Results - Visual Studio Magazine | XQuery & T-Sql | Scoop.it
Generating .NET POCO Classes for SQL Query ResultsVisual Studio MagazineAny hint of dynamic T-SQL queries should ring warning bells for security minded developers.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

Comparing EXISTS vs LEFT JOIN WHERE NOT NULL - SQL Server ...

Two of the most common ways to check for the existence of records is to use a WHERE EXISTS or to perform a LEFT JOIN WHERE values are NOT NULL. My personal choice is usually to use the EXISTS method where ...
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

Cloud Alternatives to Microsoft SQL Server | Brent Ozar Unlimited

Cloud Alternatives to Microsoft SQL Server | Brent Ozar Unlimited | XQuery & T-Sql | Scoop.it
When people say cloud, they're simplifying a lot of different solutions into a single catchphrase. Let's break out the different options and compare them. 1.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

Return Specific Row to at the Bottom of the Resultset – T-SQL Script

Return Specific Row to at the Bottom of the Resultset – T-SQL Script | XQuery & T-Sql | Scoop.it
SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script. April 23, 2013 by pinaldave. “How do I return a few of my resultset rows at the bottom of the entire resultset?” This is a very simple question – let me explain ...
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

the xmlsqlninja: mdq.XmlTransform -- Part 1: Basic XSLT in SQL ...

the xmlsqlninja: mdq.XmlTransform -- Part 1: Basic XSLT in SQL ... | XQuery & T-Sql | Scoop.it
XmlTransform can do math, parse strings, perform date calculations and almost anything else SQL can do to data. XSLT solves many complex XML problems better than T-SQL's limited XPath & XQuery functionality.
more...
Alan Burstein's curator insight, December 19, 2013 1:53 AM

I was so honored to have my article scooped that I googled scoop.it and found out about this site. Very cool site and idea. This is my first scoup. 

 

Thanks so much Tony!

Scooped by Tony Pierascenzi
Scoop.it!

Paging Data with TSQL - Database Journal

Paging Data with TSQL - Database Journal | XQuery & T-Sql | Scoop.it
Paging Data with TSQL
Database Journal
In this example I create and populate my Person table in the tempdb database. My table is populated with 12 different names.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

Use PowerShell to Clean-up SQL Server Jobs - Hey, Scripting Guy ...

Use PowerShell to Clean-up SQL Server Jobs - Hey, Scripting Guy ... | XQuery & T-Sql | Scoop.it
The Hey, Scripting Guy! Blog includes helpful how-to posts and scripts about PowerShell, Active Directory, Exchange, SQL Server, VBScript and other Microsoft technologies.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

Let's Learn XQuery [Part1: Overview] | QuickInnovations

Let's Learn XQuery [Part1: Overview] | QuickInnovations | XQuery & T-Sql | Scoop.it
XQuery is is query and functional programming language designed to query XML data like SQL from database. ... XPath is closely related to XQuery as this is used in XQuery expressions to retreive specific parts of XML.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

CTEs with Multiple Recursive Members, Part 2 - SQL Server Pro

CTEs with Multiple Recursive Members, Part 2 - SQL Server Pro | XQuery & T-Sql | Scoop.it
SQL Server Pro
CTEs with Multiple Recursive Members, Part 2
SQL Server Pro
When people write recursive common table expressions (CTEs) in T-SQL, they mostly use a single recursive member (the inner query with the reference to the CTE name).
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

10 More New T-SQL Functions - Visual Studio Magazine

10 More New T-SQL Functions
Visual Studio Magazine
10 More New T-SQL Functions. Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest. By Sam Nasr; 01/03/2013.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

The Professionals Point: Best Free XML Editors and Viewers

DOTNET, C#, Delphi, PHP, HTML5, Javascript, AJAX, jQuery, CSS3, Oracle, SQL Server Phonegap and lot more. ... XSLT to transform XML data 3. SOAP to exchange XML data between applications 4. WSDL to describe web services 5.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

T-SQL Puzzle - SQL Server Pro

T-SQL Puzzle - SQL Server Pro | XQuery & T-Sql | Scoop.it
SQL Server ProT-SQL PuzzleSQL Server ProSome time ago, I taught a T-SQL class in the UK. At the end of the class, a student named Paul Shipley presented me with a puzzle and asked whether I could find a T-SQL solution for it.
more...
No comment yet.
Scooped by Tony Pierascenzi
Scoop.it!

SQL SERVER – Auto Complete and Format T-SQL Code – Devart ...

SQL SERVER – Auto Complete and Format T-SQL Code – Devart ... | XQuery & T-Sql | Scoop.it
Some people call it laziness, some will call it efficiency, some think it is the right thing to do. At any rate, tools are meant to make a job easier, and I like to use various tools. If we consider the history of the world, if we all wanted ...
more...
No comment yet.