Viewing 15 posts - 5,281 through 5,295 (of 6,041 total)
Revenant (2/17/2012)
Draw your own conclusions, DBAs....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2012 at 11:36 am
Steve Jones - SSC Editor (2/17/2012)
Jack Corbett (2/17/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2012 at 10:18 am
RobertYoung (2/17/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 9, 2012 at 9:22 am
mw162 (2/9/2012)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 9, 2012 at 8:23 am
Viewing 15 posts - 5,281 through 5,295 (of 6,041 total)