Viewing 15 posts - 35,971 through 35,985 (of 39,804 total)
OR
If exists( select * from table where val is null)
select 'null'
else
select sum()....
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 13, 2003 at 10:45 am
Not in Enterprise Manager. You can for the login and if they use QA and the Object Browser, they should get better performance.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
September 13, 2003 at 10:44 am
Good suggestions above. If it's been working and suddenly doen't, either you have a data problem (most likely) or someone changed the code/schema.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
September 13, 2003 at 10:43 am
You need to write the trigger as if multiple records exist, so do the check as a join between the "inserted" table and the other table and perform the update...
September 13, 2003 at 10:42 am
agreed.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 13, 2003 at 10:40 am
Paritioning makes sense in some cases. Not sold on it for the main db, but for cases where you can "archive" data, moving some of it makes sense.
For instances, you...
September 13, 2003 at 10:39 am
Good idea. I'll pass along to Brian Knight, the QOD is his thing.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 13, 2003 at 10:35 am
Hey, hey, hey. I've seen the US Rowing team and we'd beat the Japanese by a mile.
BTW I used to row, so pick on some other sport.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
September 12, 2003 at 10:25 am
The statistics are used to decide which indexes to use. They help the query optimizer to make decisions.
I'd leave them alone.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 12, 2003 at 10:21 am
Do you not have a backup that works?
Try attaching the MDF without the log file (rename it) and let the system recreate it.
If that doesn't work and you are really...
September 12, 2003 at 10:20 am
Actually more urgency since it's a similar attach vector so worms could appear very quickly.
SSC is patched as of today, will get rebooted tonight.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
September 10, 2003 at 5:06 pm
No it won't. It reports an instance is already running and won't run again.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 10, 2003 at 5:03 pm
In general NO, sometimes SELECT, but that's it. I guess Execute for Sprocs. NOTHING ELSE.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 10, 2003 at 5:00 pm
I recommend that anyway. If you have corruption in the file you could lose a whole bunch of backups.
If you really want them to be the same name, rename the...
September 10, 2003 at 9:58 am
Don't you want
getdate() < dateadd(d,1,DateofAction)
?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 10, 2003 at 9:57 am
Viewing 15 posts - 35,971 through 35,985 (of 39,804 total)