Viewing 15 posts - 47,596 through 47,610 (of 49,552 total)
You have domain users granted login to the box? With what rights? If so, remove it and set up appropriate windows groups and set their permissions to just what the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2008 at 6:08 am
Is the SQL Service on that machine running?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2008 at 6:06 am
Sure. Trace the events SP:stmt_Completed and T-SQL:Stmt_completed (if you want to see individual statements in a proc/batch) or SP:completed and T-SQL:Batch_Completed
You can then filter for duration >1000 (1000 ms) to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2008 at 6:05 am
Try Solid Quality Mentors. From what I've heard, they're very, very good.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2008 at 6:01 am
The optimiser will pick a table/clustered index scan if it feels that its more efficient that multiple seeks (possibly with key lookups). It's not going to decide to scan just...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2008 at 5:59 am
LIKE '%/%%' ESCAPE '/'
Means that the character after the / is treated as a literal, not as a wildcard.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2008 at 5:53 am
Can you post the indexes that are on the table please? Also the execution plan would really help.
Run the query in management studio with the execution plan option switched...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2008 at 5:52 am
CLR is good for things that T-SQL can't do. Accessing web services, file system. For normal data manipulation - T-SQL all the way.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2008 at 5:43 am
Can you post the query please, the schema of the tables and any indexes on those tables?
Thanks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 24, 2008 at 7:04 am
The other problem with the sp_ (don't know if it was mentioned, I didn't read the entire thread) is the possibility of overlap with a system proc (current or future)
If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 24, 2008 at 7:03 am
syed muhammad naveed (1/24/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 24, 2008 at 7:01 am
David Lester (1/23/2008)
So anyone have any thoughts on this? Any suggestions on how to explain why a DBA would be important to have?
Thanks!
Ask management what their disaster recovery plans are....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 24, 2008 at 12:46 am
Mike Landa (1/23/2008)
Gail,do i need to run SQLDiag to post Error log here ?
No. It's written into the normal sql server error log. You can view the error log through...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 24, 2008 at 12:44 am
Jeff Moden (1/23/2008)
don't really see the point of an unique index with ignore duplicates on. Am I missing something?
It's a cheater method for removing dupes during a Bulk Insert...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 24, 2008 at 12:34 am
If you create a temp table in a procedure, then any procedures you call from that one will be able to see the temp table. If you create a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 23, 2008 at 11:59 am
Viewing 15 posts - 47,596 through 47,610 (of 49,552 total)