Viewing 15 posts - 2,401 through 2,415 (of 2,904 total)
My answer is that it depends.
Basically, if you mean using a 'space' for an empty string, then NULL takes up less space.
But if you are using a query such as...
October 20, 2003 at 11:18 am
My 2 cents....
1. Anyone who provides a QOD that gets used receives points for it.
2. The SQLServerCentral staff is quite busy with this site and their 'real jobs' and therefore...
October 17, 2003 at 5:56 am
From other tech sites that I use. I'll test it again the next time I test my backups. I've just never been able to get it to work without restoring...
October 17, 2003 at 5:47 am
Before you do anything else, BACKUP that log file!
Whenever you have a crash/data loss/failure/etc you should backup the existing log if possible.
Then do as Frank suggested, restore the database and...
October 17, 2003 at 5:44 am
Remember the job is running under the account that the SQL Server AGENT SERVICE is running as. Does that account have access to the database files?
-SQLBill
October 17, 2003 at 5:35 am
quote:
But that will loose the benefit of datetime data type when it comes to date calculations, and comparisons and so forth, wouldn't...
October 17, 2003 at 5:33 am
Have you ever done this and had it work? I haven't had it work yet and the answer I keep getting is that the transaction log backups apply to the...
October 16, 2003 at 10:02 am
I stick by what I said...
Per BOL (Administering SQL Server, Backup and Restore Operations, Transaction Log Backups):
The section on Restoring Transaction Log Backups says this (bolding is mine for emphasis):
It...
October 16, 2003 at 8:12 am
Can you post the data that is in the table/columns?
-SQLBill
October 16, 2003 at 7:52 am
You are right Mark. I was thinking that you were trying to CREATE the procedure on the other server. I can save a bad CREATE PROCEDURE script without it being...
October 16, 2003 at 7:47 am
To add to my last post...
both of you are searching for the WORD NULL. @lastname is a VARCHAR. NULL (meaning empty) is not VARCHAR.
Using = means to match (equality). You...
October 15, 2003 at 1:27 pm
bp,
Your query is only going to find those records like this:
au_fname au_lname
NULL ringer
That's the word NULL.
srgangu's...
October 15, 2003 at 1:22 pm
Another fine article.
I like the way you state that it's YOUR OPINION that Identity shouldn't be used. And you really didn't say it shouldn't ever be used. You just stated...
October 15, 2003 at 12:43 pm
The KILL command. Find the user(s) on the database (sp_who2 as already suggested). That will give you the SPID. Then run:
KILL <spid>
If you want to kill SPID 53, you would...
October 15, 2003 at 11:02 am
Smart move laker_42. I'm glad to see that you double check information that you are given.
And I really do mean that.
(for anyone who wonders what I'm talking about, laker_42 posted...
October 15, 2003 at 10:57 am
Viewing 15 posts - 2,401 through 2,415 (of 2,904 total)