Viewing 15 posts - 35,941 through 35,955 (of 39,771 total)
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
Tend to agree. Not sure who needs else needs it, possibly banks (financials).
More of a pain, but it's easy to pick on for questions.![]()
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
September 10, 2003 at 9:51 am
Shazam!!!
Should be better. Apologies for not snagging that sooner.
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:49 am
Great idea on the tips. We may start gathering them soon.
The book is live and shipping for those of you interested.
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:44 am
Viewing 15 posts - 35,941 through 35,955 (of 39,771 total)