Viewing 15 posts - 196 through 210 (of 287 total)
Jack Corbett (4/23/2011)
I have found that there are very few absolutes when dealing with SQL Server because so often the best solution depends on many different factors.
I have to agree...
April 24, 2011 at 9:30 am
Defrag has to be slower because it takes fewer locks and is an online operation so you can live with the longer run time because availability is not affected, whereas,...
April 23, 2011 at 8:56 am
Jack Corbett (4/22/2011)
TheSQLGuru (4/22/2011)
P.S. I specifically recommend that you do not REORGANIZE your indexes. Reorganization (defragmentation) takes about 8 times longer than rebuilding, if pages in the table are exclusively...
April 22, 2011 at 2:17 pm
Without knowing more about your index rebuilding script, I can't know if this information will be helpful. I'll volunteer it anyway:
If you're using the function call "sys.dm_db_index_physical_stats" in order to...
April 20, 2011 at 3:53 pm
mccarron52 (4/8/2011)
Other things working on server are AD, DHCP, DNS, file services, web services
This is not a criticism. I'm only commenting for the benefit of you and your company.
It is...
April 12, 2011 at 4:49 pm
For years, I have read that SQL Server was not sensitive to the order of arguments in the WHERE clause.
Your results would seem to defy that statement.
Does anyone...
April 8, 2011 at 1:37 pm
Without knowing all of the details of your situation and the problems you are having, the one thing that stands out is that the larger the database grows, the worse...
April 1, 2011 at 4:09 pm
Both are good career paths and each has its virtues. It depends on what you want out of your I.T. career, and possibly where "you're at" in life.
I spent over...
March 25, 2011 at 4:41 pm
GilaMonster (3/11/2011)....One thing with a cluster is that it has a single point of failure - the drives
Gail,
Yes, the Quorum and the MSDTC drives.
Doesn't database mirroring also have at least...
March 11, 2011 at 6:40 pm
I only recently have experience with SQL Server database server clustering.
My employer is using Windows Server 2008 R2 and SQL Server 2008 R2 on our new server. We are...
March 9, 2011 at 3:33 pm
My employer has 8 application databases on 2 servers.
Between 1:00 a.m. and 4:00 a.m., MDT, our servers tend to (but not always) hit their lowest usage point. During this...
March 9, 2011 at 3:01 pm
I have found that if you delete about 5000 or more rows, you will cause a table lock and a lockout of other applications that need to modify records in...
March 9, 2011 at 2:23 pm
Simon Facer (11/8/2010)
crainlee2 (11/7/2010)
After carefully studying the Microsoft white paper ...Do you have the link to that White Paper? I'd like to see that.
Thanks.
Simon,
Here's the link to the Microsoft Technet...
November 9, 2010 at 11:35 am
I'm sure I do. I always print hard copies of really important material.
I'll look in my "piling" system at work and get back to you.
LC
November 8, 2010 at 6:28 pm
Viewing 15 posts - 196 through 210 (of 287 total)