Viewing 15 posts - 1,501 through 1,515 (of 1,838 total)
vk-kirov (2/6/2012)
Hugo Kornelis (2/6/2012)
And 34% of them are for "you can never rollback a truncate table statement"Maybe they are Oracle refugees? :hehe: http://www.sqlservercentral.com/articles/Raw+Materials/71108/
:w00t: AHHH! I've been discovered! Oh well,...
February 6, 2012 at 10:44 am
This all sounds like yet another reason to never use SQL_VARIANT columns in your database.
December 5, 2011 at 10:51 am
I think the BI edition looks interesting, but I see a concern. Our data warehouse currently is on 2008 R2 Enterprise, using CAL licenses. Looking at Microsoft's editions...
November 17, 2011 at 10:49 am
I've been setting up database backups to occur over the network for years. The primary reason is that not every company I go to has enough disk space directly...
November 15, 2011 at 10:36 am
L' Eomot Inversé (10/5/2011)
October 5, 2011 at 10:35 am
I'd just like to say how glad I am that Jeff is a part of the SQL Server community, and say thanks for all I've learned from his writings. ...
September 21, 2011 at 11:03 am
ugh... I always outthink myself, I was sure about durable, but I thought that atomic was also violated since table variables are stored in TempDB but don't participate fully in...
September 7, 2011 at 10:50 am
Revenant (9/7/2011)
...managers get about 60 percent decisions right, no matter how many consulting bucks and effort go into that decision.That's 10 percent better than to flip a coin.
heh-heh... that makes...
September 7, 2011 at 10:41 am
I've worked at some places that you'd think the previous DBA was more along the lines of Ed Wood! :hehe: Interesting Editorial, I like the visual of thinking of...
August 1, 2011 at 10:35 am
I think it looks pretty good. In my query I use for simmilar purposes, I do a couple extra joins:
INNER JOIN sys.dm_exec_sessions s ON r.session_id = s.session_id
LEFT OUTER JOIN...
July 22, 2011 at 10:48 am
k.lasuy (7/19/2011)
If i understand correct i should add the indexes in de included_columns column.
as Nadrek mentioned, you have to take the information that dm_db_missing_index_details gives you with a...
July 19, 2011 at 11:08 am
naweed.akhtar (7/19/2011)
Which column is the 'number of reads' column?
There's actually 3 columns to look at in the query, all are from dm_db_index_usage_stats:
USER_SEEKS, USER_SCANS, USER_LOOKUPS. When those 3 numbers are...
July 19, 2011 at 10:36 am
Mike Dougherty-384281 (7/13/2011)
July 13, 2011 at 10:59 am
David Greenberg-358875 (6/20/2011)
June 21, 2011 at 9:37 am
Oops, forgot I never posted back what we did... After having Microsoft inspect the cluster, they determined there was corruption in the cluster setup database (nothing to do with SQL...
April 29, 2011 at 10:32 am
Viewing 15 posts - 1,501 through 1,515 (of 1,838 total)