Viewing 15 posts - 5,266 through 5,280 (of 6,026 total)
Revenant (2/17/2012)
Draw your own conclusions, DBAs....
February 17, 2012 at 11:36 am
Steve Jones - SSC Editor (2/17/2012)
Jack Corbett (2/17/2012)
February 17, 2012 at 10:18 am
RobertYoung (2/17/2012)
February 17, 2012 at 9:44 am
There are high value IT developers, salespeople, support staff, and executives; these are people who would have a high replacement cost if they left the company, and the cost would...
February 17, 2012 at 7:50 am
First consider there may be strong and compelling reasons to just keep the primary key on a natural non-clustered column(s) and have the table's clustered key on a timestamp or...
February 16, 2012 at 11:22 am
Describing the process of migrating a SQL Server database from one version to another as "switching a LUN" is definately a reductionist view of things.
February 15, 2012 at 9:44 am
The full Oracle client is a monster, and server admins are sometimes reluctant about intalling it. If all you need is connectivity for a linked server connection or SSIS, then...
February 14, 2012 at 8:24 am
TravisDBA (2/13/2012)
Eric M Russell (2/13/2012)
TravisDBA (2/13/2012)
It's tricky. Even if all I had available were ZIP code, birthdate and sex columns, I could still probably identify who you are. But on...
February 13, 2012 at 10:04 am
TravisDBA (2/13/2012)
It's tricky. Even if all I had available were ZIP code, birthdate and sex columns, I could still probably identify who you are. But on the other hand, If...
February 13, 2012 at 9:10 am
What can I do about a 35g sys.sysobjvalues table? My msdb database is 45g and I have cleared backup tables and mail tables. I ran a query to find which...
February 13, 2012 at 8:55 am
You might not think this is a big deal, but as more data is gathered by companies and used for secondary purposes, like analysis, it becomes more likely to be...
February 13, 2012 at 7:40 am
1) Check if you're missing any required table joins. This can easily happen and the output will be a Cartesian join ...
2) Check if you're missing any required WHERE clause....
February 10, 2012 at 7:46 am
Geoff A (2/9/2012)
Since my domain is all Windows 2008, the column logininfo_note is always either NULL or xp_logininfo returned...
February 9, 2012 at 2:03 pm
Nadrek (2/9/2012)
Very useful, though for anyone doing a more comprehensive security audit, I'd refer to Vyaskin's code, which I modified only slightly:
The script you posted is great for scripting out...
February 9, 2012 at 9:22 am
mw162 (2/9/2012)
February 9, 2012 at 8:23 am
Viewing 15 posts - 5,266 through 5,280 (of 6,026 total)