Forum Replies Created
Viewing 15 posts - 35,941 through 35,955 (of 39,771 total)
-
RE: Can this Trigger be done?
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...
-
RE: Help with tempdb
agreed.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Multi-Instancing and Vendor App Support
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...
-
RE: QOD - Answer Format
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/
-
RE: Pet Peeves
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...
-
RE: statistics _WA_
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/
-
RE: BIG PROBLEM HELPP!!!!
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...
-
RE: MS03-039 Critical - Buffer Overrun in RPCSS
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...
-
RE: Will SQL Jobs run again if already running?
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/
-
RE: Do you allow developer to access Production Server
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/
-
RE: Expiration Date/ Retain Days
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...
-
RE: Determining date range
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/
-
RE: QOD 10/10/2003
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...
-
RE: How old are you?
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/
-
RE: The Best of SQLServerCentral.com 2002
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/
Viewing 15 posts - 35,941 through 35,955 (of 39,771 total)