SQL Server: All About SQL Server Statistics : Consolidated post
Statistics is the one of the important factor which helps the optimizer to choose the right execution plan.At the same...
2013-07-10
974 reads
Building Flat File Connectors Dynamically For SSIS
Building Connectors Is Crap in SSIS – Updated
What else can I say. I finally broke when I had to build a...
2013-07-10
1,946 reads
Security Questions: Logins, Credentials, and Proxies
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-07-10
1,670 reads
Hung SQL Server Restores from Tivoli Storage Manager/Tivoli Data Protection
I ran into this with a client last night when trying to restore their SQL Server data warehouse database from...
2013-07-10
2,499 reads
70-457 Reviewer #02, What is Columnstore Index?
Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index...
2013-07-10
833 reads
Security Questions: Logins Not In Use
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-07-10
601 reads
energy
Back when I was trying to start a business and unknowingly heading towards a economic cliff, I read all sorts...
2013-07-10
594 reads
Find out orphan database file on disk
Sometimes you detach databases, or you delete a database which is in restoring status, the data and log file will...
2013-07-09
2,364 reads
PowerSQL – Find OS and Memory Usage Details – Multi Server Script – No Input files
Multi Server script to find OS and Memory details. It doesn’t require a text file as its input but you...
2013-07-09
915 reads
PCI Compliance Presentation on July 17, 2013
Next week I’ll be doing a new presentation about PCI compliance – aka dealing with credit cards – online (follow this link...
2013-07-09
534 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers