Viewing 15 posts - 76 through 90 (of 472 total)
opc.three (6/7/2011)
You may be encountering page splits on update now that you have a variable length column in the table.What is the fill factor setting on your clustered index?
Hadn't thought...
The Redneck DBA
June 7, 2011 at 9:10 am
GSquared (6/7/2011)
You're running into issues with padding and implicit conversion.
I figured something along those lines, and agree it wasn't ideal to have it be a CHAR type to start with,...
The Redneck DBA
June 7, 2011 at 8:58 am
jmerrill 28016 (5/16/2011)
Other than the fact that it was an advertisement for a commercial product, what was particularly incorrect on the page you referenced?
Advertising aside, isn't it pretty irresponsible to...
The Redneck DBA
May 16, 2011 at 12:30 pm
Shouldn't you also disable the user in SQL? (making sure you aren't dropping the only sysadmin)
The Redneck DBA
April 22, 2011 at 7:52 am
stebennettsjb (3/2/2011)
The Redneck DBA
March 8, 2011 at 1:58 pm
I tried to rebuilt it, and it just sat there seemingly doing nothing for a couple of hours. I finally got to poking around and the folder/files that made...
The Redneck DBA
March 5, 2011 at 8:32 am
Anyone know when this will be officially published?
The Redneck DBA
March 4, 2011 at 2:18 pm
Will granting VIEW DEFINITION permissions work?
The Redneck DBA
February 16, 2011 at 11:50 am
From BOL:
SQL Server 2005 collations can be specified at any level. When you install an instance of SQL Server 2005, you specify the default collation for that instance. Each time...
The Redneck DBA
February 16, 2011 at 11:41 am
Warren Peace (1/27/2011)
The Agent job Owner has sa server role membership.:
It has SA rights in SQL server, but are sure it has necessary rights/configuration to hit the Oracle data?
The Redneck DBA
January 28, 2011 at 11:27 am
Geoff A (11/16/2010)
The Redneck DBA
November 17, 2010 at 6:18 am
Jeffrey Williams-493691 (11/16/2010)
However, if you are running in synchronous mode - you...
The Redneck DBA
November 17, 2010 at 6:16 am
Just keep in mind thing like index rebuilds on large tables can cause a large amount of data to change, which in turn causes a large volume of data to...
The Redneck DBA
November 16, 2010 at 12:30 pm
Why do you think you need to suspend mirroring before you rebuild indexes?
The Redneck DBA
November 16, 2010 at 8:59 am
Viewing 15 posts - 76 through 90 (of 472 total)