Viewing 15 posts - 1,306 through 1,320 (of 2,436 total)
Size is relative. My temdb's vary from 1 Gb to 10 Gb. It's just what is 'normal' for that server. Oh, I definitely agree with Jeff ...
May 26, 2006 at 11:51 am
A rather dicy thread here ...
Before SQL 2005 the same issues existed more or less. It'sjust that SQL 2005 added CLR integration (check out other threads on this site for...
May 26, 2006 at 11:36 am
Just a note on passwords, in particular 'strong' passwords. You need not got to the lengths of 'pass phrases', multiple words with spaces, if you use a 16 character password...
May 26, 2006 at 11:23 am
By default, the SQL Agent service is not even configured to autostart, let alone have existing JOBs. IFirst I'd check the execution history then I'd script them out and take...
May 25, 2006 at 4:36 pm
Yelena,
sp_recompile is not a replacement, it and sp_refreshview simply marks the object and any SP that references that object will have it's plan recreated on the next execution in essence...
May 25, 2006 at 3:45 pm
Query Analyzer
Enterprise Manager
SQL Server MSX Server
Custom scripts
MOM - Microsoft Operation Manager
Windows perfmon
SQL Profiler
and ...
SQL Server Central dot com
SQL Performance dot com
May 25, 2006 at 1:57 pm
I've had to do the same thing in the past. However the best place to start for this information is generally the source. Who does the hiring/firing ? This is...
May 25, 2006 at 1:52 pm
Here's my 'short list' for tuning:
Round I
DBCC UPDATEUSAGE
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
exec sp_refreshview for all views
Round II
DBCC DBREINDEX
...
May 25, 2006 at 1:40 pm
If you can you write a transact SQL query for SQL Server or a SQLPlus query for Oracle then using Queryman or Toad is no different. However if you cannot write...
May 25, 2006 at 9:17 am
To get at he things I mentioned:
Start-Programs-Microsoft SQL Server-Query Analyzer
What exactly are you try to do ? Learn SQL ?
May 24, 2006 at 2:28 pm
Why do you need to use those tools ? SQL Server has QA - Query Analyzer. As for the assistance woth QA, well there is BOL - Books Online.
May 24, 2006 at 1:21 pm
You quest may be further complicated by applications as well. Some applications use multiple connections, some applications use generic IDs with application security ID's not visible to sysprocesses or to...
May 24, 2006 at 12:24 pm
Your Domain Admins can give you the exact information that you want, login name. Tey just have to use a couple of extra check boxes and ad a few more...
May 24, 2006 at 12:19 pm
I do not have a solution but a question. Why are you using a local 'hosts' file instead of DNS ?
May 24, 2006 at 12:16 pm
Viewing 15 posts - 1,306 through 1,320 (of 2,436 total)