-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: June 2018

Does a Primary Key always have stats_id 1?

Back to the SQL Server Basics with Wayne

The Myth

I recently was attending a presentation where the presenter stated that the statistic with stats_id = 1 is always for the primary key (PK). The presenter made this statement based on the behavior that he has seen. However, is it… Read more

0 comments, 2,073 reads

Posted in A Discussion of SQL Server-Related Topics on 28 June 2018

SSMS reset window layout (Day 37)

SSMS is a wonderful tool. You can drag Windows around, grouped with others, split, docked, undocked, hidden… it seems endless what you can do with them. You can even change what columns you see. Invariably, with all of this customization, things go wonky. I’ve even seen windows opened up… Read more

0 comments, 2,178 reads

Posted in A Discussion of SQL Server-Related Topics on 20 June 2018

New blogger: Jamie Wick

New SQL blogger

Jamie at the 45th Parallel (South) – New Zealand

This post is just a quick shout-out. My friend and co-leader of the Richmond SQL Server User Group, Jamie Wick, has started blogging. You can catch all of the action at his blog. He has some… Read more

0 comments, 182 reads

Posted in A Discussion of SQL Server-Related Topics on 15 June 2018

Removing the time element from a datetime

Killing Time – or removing the time element from a datetime

Over the course of time, we all collect scripts and routines for helping us do our job. Recently, I ran across two routines that are removing the time element from a datetime data type that I hadn’t seen before.… Read more

1 comments, 1,583 reads

Posted in A Discussion of SQL Server-Related Topics on 7 June 2018