SQL 2012 has Launched
LAUNCH
If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched. With it,...
2012-04-01
988 reads
SQL RNNR
SQL 2012 has Launched
LAUNCH If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched. With it, some really cool features are now available to...
2012-04-01
3 reads
Seldom Used Indexes
On occasion you may ask yourself if there are any under used indexes in your database. If not you, then...
2012-03-26 (first published: 2012-03-20)
2,412 reads
Seldom Used Indexes
On occasion you may ask yourself if there are any under used indexes in your database. If not you, then possibly a manager or client. Usually this comes up...
2012-03-20
1 reads
Another Interesting Sort
In October of 2011, I shared an example of a peculiar set of sort requirements. Today, I am going to...
2012-03-19
843 reads
Another Interesting Sort
Some code requirements can be met through various means including the use of a different collation - which means a lot of testing.
Related Posts:
Creative Database Naming January 2, 2020...
2012-03-19
3 reads
Agent Jobs Using SSIS
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those...
2012-03-15
851 reads
Agent Jobs Using SSIS
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those cases where you are consulting or you have taken...
2012-03-15
8 reads
Table Size and Missing FK Indexes
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a...
2012-03-14
1,108 reads
Table Size and Missing FK Indexes
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a couple of different queries that I like to use....
2012-03-14
4 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers