Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.
2011-12-23 (first published: 2009-07-20)
40,444 reads
SQL Server architect David Poole sets about exploring sp_prepexec when called from nHibernate.
2011-12-08
9,641 reads
Mind mapping software allows the rapid capture of thoughts and ideas. It is a killer app that can easily help a busy DBA capture their thoughts
2011-12-01
8,010 reads
A lively comparison of Pascal's triangle to root cause analysis from David Poole.
2011-10-19
4,472 reads
2011-09-15
11,609 reads
An interesting mystery on why some nHibernate performance issues might exist on your systems. Read this piece from SQL Server expert David Poole and look to see if this is a problem you can easily solve in your environment.
2011-04-11
6,127 reads
Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.
2010-08-13 (first published: 2008-08-13)
61,074 reads
David Poole takes a look at the Massively Parallel Processing world for database servers.
2010-08-11
4,555 reads
In a sequel to his first article on Time Bomb Design, David Poole examines the issues we find between development environments and production ones.
2010-05-26
10,547 reads
Replication is a great technology for moving data from one server to another, and it has a great many configuration options. David Poole brings us a technique for scaling out with multiple distribution databases.
2010-03-30
10,885 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers