Viewing 15 posts - 151 through 165 (of 1,348 total)
does this work on sql 2005? i set up a SQL 2008 R2 test server to practice on and one of the first things i wanted to do was collect...
March 4, 2011 at 12:43 pm
about 400GB or so for 30 days of data
every day i have vb scripts dump security and application log data from domain controllers, sql and other servers into a central...
February 28, 2011 at 9:16 am
thx
going to have to play with this. i have a huge database on a SQL 2005 server with full text indexing enabled and it can really be a PITA a...
February 28, 2011 at 8:56 am
aroatenberry (2/14/2011)
Our OS and SQL server is 32 bit though
i would run a trace then to see the queries casing this. i've seen people write code to scan hundreds of...
February 14, 2011 at 12:51 pm
index hints are evil
after a few years you may want to get rid of the index to improve performance and it will like pulling teeth getting people to change code.
February 14, 2011 at 12:44 pm
there was a blog posting on MSDN a few years ago by one of the devs. when we first went to x64 a few years ago we had the exact...
February 14, 2011 at 12:40 pm
seen this in the last month in my environment
we have a table and the devs complained about poor performance. got rid on a unique index that enforced a constraint on...
February 14, 2011 at 12:37 pm
if the OS and SQL is x64 you should enable lock pages in memory
February 14, 2011 at 12:31 pm
i looked at Fusion IO and similar products and may see if we can buy them this year. from what i read you get best results putting your tempdb or...
February 14, 2011 at 12:30 pm
amenjonathan (2/14/2011)
Tom.Thomson (2/11/2011)
amenjonathan (2/11/2011)
1. If a column is...
February 14, 2011 at 12:09 pm
thx
i've been meaning to add this to my daily data collection. i'll probably just change the process to use SSIS to import data for numerous servers into a central database
February 14, 2011 at 6:33 am
i have a process set up that dumps audit data from domain controllers to a database and last year i caught a user being added to a group that had...
February 10, 2011 at 9:48 am
question, how hard is it to get published on the kindle and ibooks?
i have a skeleton story i play around with sometimes and thought about selling it for $.99 a...
February 10, 2011 at 8:06 am
solomon.jernas (2/9/2011)
February 9, 2011 at 8:18 am
what is your SQL build numbers? there were bugs like this in some older builds
February 9, 2011 at 7:54 am
Viewing 15 posts - 151 through 165 (of 1,348 total)