Viewing 15 posts - 36,076 through 36,090 (of 39,903 total)
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
Agree with that, but for most systems, most people, sparing a few constant I/Os along with 5% of the CPU might be a big benefit.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
September 10, 2003 at 9:43 am
This should help
If not, hopefully someone else has some resources.
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:41 am
It does upgrade MDAC (potentially) to 2.71 (I think this is right, 2.7something). This could be an issue for some apps, I know it was here at J.D. Edwards. Some...
September 10, 2003 at 9:35 am
Viewing 15 posts - 36,076 through 36,090 (of 39,903 total)