Viewing 15 posts - 6,046 through 6,060 (of 6,678 total)
homebrew01 (10/16/2008)
- Create a Global Group,
- Put Windows users in the Global Group,
- Put that Global Group in a...
October 16, 2008 at 1:50 pm
The only thing I can think of is to use row_number(). You can create a view that is used to select from the table that includes the row_number() calculation...
October 10, 2008 at 4:45 pm
You can find references to incremental backups for SQL Server in the SMO documentation. From there, an incremental backup is equivelant to a differential backup in SQL Server.
Using SMO...
October 2, 2008 at 2:20 pm
rbarryyoung (9/30/2008)
Yeah, if I do have to do this, I would much rather use OPENQUERY than xp_CmdShell.
I have to agree with this - especially since you cannot be assured that...
September 30, 2008 at 1:48 pm
rbarryyoung (9/30/2008)
Wouldn't you want to do it like this?:
SELECT *
FROM table1
LEFT JOIN (table2 INNER JOIN table3 ON table3.fkey = table2.Pkey)
ON table2.fkey = table1.Pkey
Absolutely,...
September 30, 2008 at 1:36 pm
tbeadle (9/29/2008)
While it's true the "non-standard' outer joins are depreciated, they do work and will work quite some time into the future. Microsoft depreciated announcements do not mean the...
September 30, 2008 at 12:24 pm
tbeadle,
Your recommended solution will not work because it is using non-ANSI outer join operators. Those operators have been deprecated in SQL Server 2005.
To the OP - the other solutions...
September 26, 2008 at 5:46 pm
Deleting data from the database will not shrink the database file size. What you are seeing is correct and is what I would expect.
BTW - you want to have...
September 26, 2008 at 5:37 pm
You are still going to use CONVERT - but, you need to tell it what style. Look up CONVERT in Books Online for the correct style to return just...
September 26, 2008 at 2:41 pm
Yeah - that's what I think also, based upon the original post. Still, have to wonder why someone would run 12 instances on a system with only 4GB of...
September 26, 2008 at 2:14 pm
Unfortunately, I only have SQL Server 2008 installed on this workstation - so the link I have would not work for you.
If you open Books Online (or, from SSMS go...
September 24, 2008 at 5:17 pm
Try defining an operator that only receives notifications using net send. Then, use sp_notify_operator to send a notification to that operator.
I haven't tested it myself - but, it should...
September 24, 2008 at 5:13 pm
If you don't want to look at clustering - consider Database Mirroring instead. You could replace your log shipped database with a mirror, setup a witness for failover and...
September 24, 2008 at 4:07 pm
You should rebuild your indexes as often as needed. I don't know your system or how often your indexes are becoming fragmented - so, I really couldn't say whether...
September 24, 2008 at 4:01 pm
Viewing 15 posts - 6,046 through 6,060 (of 6,678 total)