Viewing 15 posts - 4,696 through 4,710 (of 7,191 total)
Got it right, but I think the answer should be "it depends". On what? The selectivity of the data in Col. You get a seek if you...
February 17, 2012 at 2:10 am
Your last two posts don't make sense to me. Please will you post some sample INSERT statements and show what the new rows in ORDERS should look like after...
February 17, 2012 at 1:36 am
This will happen if you use BACKUP LOG TO DISK = 'x:\MyFolder\MyBigLogBackupFile.TRN' and you don't specify WITH INIT. Use RESTORE HEADERONLY to check how many backups are in the...
February 16, 2012 at 4:44 am
Yes, after you take your next full backup, if you delete the 79GB log backup, you will only be able to restore to a point in time after the full...
February 16, 2012 at 4:28 am
It isn't a script at all. It's a snippet from the documentation for ALTER TABLE... which name should suggest to you that it's to alter one table at...
February 15, 2012 at 8:29 am
I've never used this before, but this snippet from the ALTER TABLE documentation suggests you can drop more than one column at once:
| DROP
...
February 15, 2012 at 8:14 am
You need to set up a linked server on the server on which you create the proc.
John
February 15, 2012 at 5:36 am
Formatting is something that's better done in the presentation layer. However, if you insist on doing it in the data layer, just convert the number to varchar(4) and concatenate...
February 15, 2012 at 4:02 am
Mithra
Soon after SQL Server starts, there is a message in the errorlog something like "The NETBIOS name of the local node that is running the server is 'NODE1'. This is...
February 15, 2012 at 2:34 am
Are we talking about a cluster server here? You can look at the Windows event log and see whether any particular start of SQL Server occurred on the same...
February 15, 2012 at 2:08 am
Also, I would strongly recommend using different domain accounts for test and live servers. Think about it - at the moment, everything that your live server has access to,...
February 15, 2012 at 2:02 am
No they shouldn't. A table is an unordered set. The database engine will retrieve rows from a table in the way and in the order it judges most...
February 14, 2012 at 5:01 am
Appalled? I usually reserve that reaction for earthquakes, famines, wars and so on.
In any case, I don't agree that just because two statements are posted on the same page...
February 14, 2012 at 4:30 am
The only (easy) way I can think of for achieving anything like that is to use sqlcmd and pipe the output into your text file.
John
February 14, 2012 at 4:04 am
Viewing 15 posts - 4,696 through 4,710 (of 7,191 total)