Viewing 15 posts - 1 through 15 (of 35 total)
Here is an article 'How to Identify Non-Active SQL Server Indexes'.
using Profiler and the Index Tuning Wizard with recommendations on Profiler settings, as you requested;
It looks tedious but could...
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
August 8, 2006 at 4:41 pm
Thought I'd mention a sidebar issue related to this...
Be sure to EXEC sp_spaceused @updateusage = 'TRUE' for each DB sometime soon before you collect your data. Without the...
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
July 19, 2006 at 1:36 pm
Savass -
I feel your pain. Since you have done all the standard things to remedy this, here's the short version of what you need to know:
I assume your DB...
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 28, 2006 at 6:40 pm
DTS is also a multi-threaded native SQL Server 2000 component.
DTS Packages can be written to execute many tasks simultanaously rather than serially. For example, you can define multiple connections...
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 28, 2006 at 6:21 pm
Hi James -
This is Cognos Planning, isn't it?
I recall the installation team/developers installing and leaving, then me checking disk about 3 months later and seeing the media set...
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 23, 2006 at 1:57 pm
Tejwant -
This article by Brian is a good functional description of Cluster configuration;
http://www.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine__2.aspI
I have only done Active/Passive Failover clustering on a shared SAN.
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 21, 2006 at 7:13 pm
I encourage you to check out the following two articles;
For more detail on SQL Server/SAN configuration specifics;
http://www.sqlservercentral.com/columnists/hscott/asanprimer.asp
For your Clustering questions;
http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp
I completely agree that you need to be planning...
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 21, 2006 at 6:47 pm
Mike -
I gather since you shrunk the Transaction Logs (*.ldf) to gain some space that they are on the same storage array as Data files (*.mdf). That's not the...
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 21, 2006 at 6:28 pm
Security Options/Interactive Logon: Number of previous logons to cache (in case domain controller is not available).
When going LIVE with a domainless standalone SQL Server, one Local Windows account User/SID...
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 12, 2006 at 11:52 am
Thanks for clarifying this for me, David. Much appreciated!
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 11, 2006 at 11:06 am
See what happens when you toggle the Query Analyzer Connection option 'Use regional settings when outputting currency, number, dates, and times'
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 9, 2006 at 5:14 pm
Apologies if you've already gone through this litany of questions, Mordechai. Just doing a little fishing...
I see this is not Linked Server or Distributed Query. Both SQL Server 2000/same SP?
Using...
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 9, 2006 at 4:25 pm
Do both servers have the same OS level Regional Settings?
Are there NULLs in the Resultset of the failing query?
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 9, 2006 at 1:34 pm
Bryan -
Some of my work is in a Domainless World, and we have a number of external web applications (outside our Domain) that access our SQL Server 2000 instance using Integrated...
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 9, 2006 at 12:44 pm
Steve, I couldn't agree more about the Conference attendance being part vacation/part intensive training. if you're lucky enough to work someplace where that is recognized as a good thing, it's...
Stuart
"Chance is always powerful. Let your hook be always cast. In the pool where you least expect it, will be a fish" - Ovid
June 8, 2006 at 5:55 pm
Viewing 15 posts - 1 through 15 (of 35 total)