October 2011 SQL Server 2012 Diagnostic Information Queries
Since Microsoft released the official name for “SQL Server Code Named Denali” last week at the PASS 2011 Summit, it...
2011-10-19
830 reads
Query Memory Spills
When you sometimes look at Execution Plans, you can see that the SELECT operator has
sometimes a so-called Memory Grant assigned....
2011-10-19
5,147 reads
No longer just an admin but a DB Astronaut : A poem.
Today we have a guest post from Phil Factor as Brad is on vacation.
‘ I used to fettle databases as...
2011-10-19
550 reads
More Denali Execution Plan Warning Goodies
In my last blog, I showed how the execution plan in denali has been enhanced by 2 new warnings ,conversion...
2011-10-19
793 reads
Microsoft and HP’s Database Consolidation Appliance
Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (see my blog about the other two appliances). ...
2011-10-19
1,787 reads
3D Printing for Under $1000
I saw this about the iModela 3d printer, it’s priced under $1000, making it approachable if not quite cheap. 3d...
2011-10-19
624 reads
Moving to House of Brick
Starting Halloween Monday I will be a Technical Consultant for House of Brick Technologies.
To everyone out there saying "Didn't you...
2011-10-19
534 reads
Culture Posters
I work with a client now that had a poster made of the top 10 values for the IT department....
2011-10-19
622 reads
Announcing the fifth certification study session
The Denver SQL Server User Group is starting another round for the certification study group. Last year we ran three...
2011-10-19
989 reads
SQL Server – Moving table with LOB data to different file group
Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work*...
2011-10-19
2,693 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers