Viewing 15 posts - 5,266 through 5,280 (of 6,022 total)
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
Revenant (2/3/2012)
Eric M Russell (2/3/2012)
. . . We developers tend to forget things like that unless someone in the organization is keeping score.
That's what TFS does - if you use...
February 3, 2012 at 1:11 pm
jkp2311 (2/3/2012)
Do i need the Microsoft office 2007 in my machine...?
On the machine running SSMS Data Import Wizzard, SSIS, etc. you would need the Excel data provider installed. SQL Server...
February 3, 2012 at 1:05 pm
If you work for a publicly traded company in the US, then a compliant change management process is required by SOX.
I think that those who work in an organization...
February 3, 2012 at 12:01 pm
jkp2311 (2/3/2012)
I have get some crazy error when i am trying to import data
from Excel sheet to SQL Server table using SSIS Packages.
PLease read the below error message.
Please help me...
February 3, 2012 at 11:51 am
Viewing 15 posts - 5,266 through 5,280 (of 6,022 total)