The Performance Impact to Prefix Stored Procedures with sp_
Last week I ran across a blog post by Axel Achten (B|T) that outlined a few reasons why you should...
2013-02-19
1,423 reads
Last week I ran across a blog post by Axel Achten (B|T) that outlined a few reasons why you should...
2013-02-19
1,423 reads
Per Books Online, DBCC SHOW_STATISTICS displays current query optimization statistics for a table or indexed view. Basically it shows you...
2013-02-14 (first published: 2013-02-05)
5,303 reads
T-SQL Tuesday - This month's party is hosted by Wayne Sheffield (blog|twitter), and the topic is about Powershell and how to use...
2013-02-12
8,049 reads
I have seen plenty of articles and blog posts out there for how to setup and implement table partitioning, but...
2013-02-04 (first published: 2013-01-29)
5,782 reads
During your career as a DBA, you'll run across articles by SQL experts or other DBAs that just give you...
2013-01-22
1,277 reads
For years, actually more like a decade, I've been saying that I'm going to get certified in SQL Server. Well...
2013-01-15
738 reads
Have you seen this type of an informational message in your SQL errorlog before? If so, then I hope the...
2013-01-07
999 reads
In a previous blog post, I demonstrated how you can use an undocumented stored procedure, master.sys.xp_dirtree, to list all files...
2012-12-31
22,212 reads
Last week, I attended my very first SQL Saturday event in Washington, DC. Although I don't live anywhere near Washington,...
2012-12-18
541 reads
You may have noticed in my code examples, I always include a semicolon ";" at the end of my TSQL statements. ...
2012-12-11
989 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
Comments posted to this topic are about the item Speakers Are Normal People
Comments posted to this topic are about the item Publishing a Public Power BI...
Comments posted to this topic are about the item Automatic Formatting of Code