Viewing 15 posts - 1 through 15 (of 121 total)
SQL Server seems to be growing steadily.
The recent announcement that SQL Server will be available on the Linux OS gives me even more confidence that Microsoft is making the right...
March 30, 2016 at 12:49 pm
Thanks for the reply.
The issue that prompted the question is that the place I have been working the past few months has 100% of the SQL Server systems on VMWare....
January 11, 2016 at 7:39 pm
I would say it should be about 20% more. Just my guess. I would like to hear other opinions on this.
December 26, 2015 at 11:16 am
Paul Randal,
What would you suggest for those that cannot do the 'verify backup integrity' due to time constraits?
In my environment we have multiple production database clusters, each with multiple...
September 24, 2012 at 12:17 pm
QUESTION: The database maintenance plan dialogs in Microsoft SQLServer2000 (yes, we're still running it) has a "Verify the integrity of the backup upon completion" option.
The problem with that...
September 24, 2012 at 10:27 am
We are testing the ONLINE partitioning process this week. But if we do it that way, it is definitely a performance hit. So we are trying to figure out how...
September 17, 2012 at 4:00 pm
Reason = query performance on the table with partition elimination. Also index maintenance going forward.
I understand what you are saying with the update trigger directly to the new partition...
September 17, 2012 at 1:53 pm
We discussed that as an option. Create a shadow partition table and gradually crawl through the original table to partition the data over time. Then we will just rename tables...
September 17, 2012 at 12:44 pm
Now I remember why I avoid this forum most of the time.
If you don't feel comfortable doing it, dont do it.
For those of us with experience, it is a...
September 12, 2012 at 5:46 pm
The relevant point is that the adding of multiple files to Tempdb won't hurt a SQL Server with a light load and it will likely help on a SQL Server...
September 12, 2012 at 1:53 pm
lianvh (9/11/2012)
I am frustrated, because , a consultancy firm used this tool and now to keep the peace we have to implement this setting.
There is nothing wrong with doing this...
September 12, 2012 at 12:54 pm
Chuck Norris can gargle peanut butter.
Chuck Norris can slam a revolving door.
Chuck Norris can design databases so amazing that they don't even need indexes.
May 25, 2012 at 10:57 pm
I always blame Chuck Norris when anything goes wrong. He is unstoppable.
Chuck Norris was born on May 6th, 1945
Nazi Germany surrendered on May 7th, 1945.
May 25, 2012 at 6:01 pm
GSquared (5/14/2012)
Since the last time it hit the active threads, I've concluded that the lack of senior DBAs is...
May 14, 2012 at 2:57 pm
Viewing 15 posts - 1 through 15 (of 121 total)