Forum Replies Created
Viewing 15 posts - 35,896 through 35,910 (of 39,903 total)
-
RE: Does Access effect SQL Server Perfomance
run a profiler trace.
Access can at times really hinder performance because it asks for a bunch of data from SS.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Best way to NOT to RUN a job on a list of dates
KISS it. I vote for tejeshc's solution.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Long executive plan, long compile? Why?
Compilation can be a substantial portion of the execution time, but 2-3 minutes seems excessive, even for something as complicated as you have here.
given that, you might consider working on...
-
RE: Recovery model from simple to full
IS it happening when a maintenance is run the night before? Some of theoptions try to throw the db into single user mode, might mess with the recovery model. Shouldn't,...
-
RE: Backups failing on 1 of 4 databases
Disk space?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Subscription on articles
It's on and off based on the server load. The list manager for newsletters interferes with it.
We're working on it.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: database design - vertical partitioning question
Tend to agree with Andy. Partitioning can work, but gets complex and usually requires some application work. Paritioned views would probably help, but would be some serious $$.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best...
-
RE: How can I tell if a table isn't being used anymore
If you select "Locks" you will get smacked. I'd get just TSQL and RPC, either start or finished and let if run. The scan the results (the textdata column) for...
-
RE: SQL Mail and Yukon, what do you want to see...
Yes, yes, yes.
1.allow HTML formatting.
2.use SMTP
3.Don't require Outlook or build in a MAPI client to the product.
4.Allow multiple email addresses to send from, authentication could be included in the send...
-
RE: Acronyms
IMHO - in my humble opinion
one I like. RTFM, but not very PC in the US. Some people get offended.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Can NOT edit my messages
That's strange. Which message?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: SqlServerCentral.com... The Book?
Thanks for the updates and the purchases!!
Hopefully you are all pleased.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: ASP
Do you have the
<%@Language=VBScript%>
at the top.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Cycling Those Error Logs
I rarely get errors in the SQL logs, however, all backups are logged and with Tlogs every 15 minutes, we are talking a lot of entries over a month. Cycling...
-
RE: Veritas banner
Apologies if it's annoying. We don't really censor their ads, but they are paying us, which lets us continue to correspond with you, Frank
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best...
Viewing 15 posts - 35,896 through 35,910 (of 39,903 total)