Tags » Microsoft SQL Server

SQL Server Statistics and Trace Flag 2371

— by Lori Brown @SQLSupahStah

Statistics are pretty important to SQL Server. Statistics are small objects that hold information of the distribution of data in a table. 815 more words

SQL Server

A quick fix for a full identity column.

A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following:

  • Negative increments can be handy if your identity column has reached the max value of the data type.
  • 592 more words
SQLServerPedia Syndication

North Texas SQL Server User Group - September 2016 Follow

Thanks for attending my presentation on window functions in TSQL during the September 15, 2016. I hope you learned something you can take back and use in your projects or at your work. 147 more words

Microsoft SQL Server

Using an ORDER BY in a view

For many years it’s been a best practice to never put an ORDER BY in a view. The idea is that a view shouldn’t have an inherent order. 217 more words

SQLServerPedia Syndication

Setting up Disconnected Log Shipping

— by Lori Brown @SQLSupahStah

I have a few clients who have set up SQL instances to hold copies of databases from either vendors or other companies with whom they are actively sharing data with. 3,353 more words

SQL Server

Emojis in SQL Server

I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about… 126 more words

SQLServerPedia Syndication

Script To Detach All User Databases on SQL Server

Here is a query to generate a script to detach all user databases on your SQL Server.

Once you have run the query, copy the output and run it in SSMS to detach all your user databases. 138 more words

Microsoft SQL Server