Start with stupid
True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked...
2014-03-17
571 reads
Kenneth Fisher
:CONNECT in SSMS
Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...
2014-03-13
1,427 reads
T-SQL Tuesday #52: Keep your head down!
It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has...
2014-03-11
1,283 reads
Impersonating a server level permission
Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...
2014-03-07 (first published: 2014-02-26)
2,289 reads
Characters you should never ever use in an object or schema name!
You can put pretty much any character you want into an object or schema name by enclosing the name in...
2014-03-05
702 reads
Using SQLFiddle
SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...
2014-03-03
2,564 reads
What’s the difference between a temp table and a table variable?
I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...
2014-02-24
1,089 reads
Finally added a (t) to my (b)
I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter....
2014-02-20
503 reads
DBA Myths: An index on a bit column will never be used.
Not true. (Or I guess probably wouldn’t be posting about it would I?)
Probably the first thing I should point out...
2014-02-19 (first published: 2014-02-17)
2,599 reads
Getting a query plan
Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware...
2014-02-19
1,476 reads
Blogs
How Long Will It Take to Learn SQL? The Truth Might Surprise You
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Flying Halfway Around the World to Australia
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
Dealing with Change – Two Resources
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Forums
Table with FK(s) to other columns within the table
Hello All, I have recently joined a project, where main, core tables with millions...
SQL 2017 throwing BugCheck on differential database restore
Long time listener, first time caller. I have a problem that my usual bag...
cluster node quarantined
evening All hoping someone can shed some light - I have a (originally) 2...
Question of the Day
Using Table Hints in a Query
How many table hints can I include in a query?
See possible answers