SQL Tips and Tricks Archives - Page 289 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – Download Whitepaper 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

December 3, 2011

Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting configurations to parameters,…

SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT

December 2, 2011

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

Today I had very interesting experience when I was presenting on SQL Server. While I was presenting the session when I ran query SQL Server Management Studio returned message like (8 row(s) affected) and (2 row(s) affected) etc. After a while at one point, I started to prove usage of @@ROWCOUNT function.

SQL SERVER – Where Can YOU Get My Books – SQL Server Interview Question and Answers

December 1, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Best Practices, SQL Documentation, SQL Download, SQLAuthority Author Visit, SQLAuthority Book Review

Earlier month I released by third book SQL Server Interview Question and Answers. The focus of this book is ‘master the basics’. If you rate yourself 10 out of 10 in SQL Server – this book is not for you but if you want to learn fundamentals or want to…

SQL SERVER – Using expressor Composite Types to Enforce Business Rules

November 29, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation

One of the features that distinguish the expressor Data Integration Platform from other products in the data integration space is its concept of composite types, which provide an effective and easily reusable way to clearly define the structure and characteristics of data within your application. An important feature of the…

SQLAuthority News – SafePeak’s SQL Server Performance Contest – Winners

November 28, 2011

Pinal Dave

SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks

SafePeak, the unique automated SQL performance acceleration and performance tuning software vendor, announced the winners of their SQL Performance Contest 2011. The contest quite unique: the writer of the best / most interesting and most community liked “performance story” would win an expensive gadget. The judges were the community DBAs…

SQL SERVER – Powershell – Get a List of Fixed Hard Drive and Free Space on Server

November 27, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell, SQL Scripts, SQL Stored Procedure

Earlier I have written this article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server. I recently received excellent comment by MVP Ravikanth. He demonstrated that how the same can be done using Powershell. It is very sweet and quick solution. Here is the…

SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree

November 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

Many years ago I wrote article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server where I demonstrated using undocumented Stored Procedure to find the drive letter in local system and available free space. I received question in email from reader asking if there any…