Viewing 15 posts - 43,546 through 43,560 (of 49,552 total)
Please post table definitions, index definitions and execution plan (saved as a .sqlplan file, zipped and attached)
How many rows are in the tables? How long does the query run for?...
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
October 27, 2008 at 1:33 am
r.dragoi (10/23/2008)
Can you do a test changing the isolation level ?I would change it to read uncommitted , in your case is read committed.
Isolation levels only...
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
October 27, 2008 at 1:26 am
You can script the indexes and just apply them on the other server. Import/export just moves the data
Go to object explorer in management studio, expand out until you see 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
October 27, 2008 at 1:17 am
nairsanthu1977 (10/27/2008)
Dear All,Sometimes my database goes very slow. I would like to finetune the database.
Can anyone suggest wot are the things to be done please.?
That's a very open question.
Make sure...
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
October 27, 2008 at 1:16 am
nairsanthu1977 (10/27/2008)
For time being whot I have done is, I EXPORTed all the tables from EMERGENCY databse to another temporary database. Also I copied all the SPs. So now data...
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
October 27, 2008 at 1:12 am
Profiler records events that occur on the server. The events range from SQL queries executed to locks acquired, to logins/logouts, to deprecations, deadlock and a whole lot more.
Performance dashboard is...
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
October 27, 2008 at 12:50 am
If you're trying to move the DB, detach it. If you do it through management studio, you can specify to drop all connections first. Then you can move the files...
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
October 27, 2008 at 12:42 am
What error did the initial detach give? (error code's fine. I can use that to get the english version)
What error did the attach_single_file give?
Do you still have the mdf and...
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
October 27, 2008 at 12:41 am
Stephanie J Brown (10/26/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
October 26, 2008 at 10:04 am
Are you looking for a way to automatically get the names and paths of the images that are in the file system into the table? Will it be a once-off...
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
October 26, 2008 at 5:09 am
Two options. Have a column in the table that stored the full path and filename, or you can put the entire picture in the table using a varbinary(max) column
If that...
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
October 26, 2008 at 4:16 am
There is no way you're going to be able to get that result straight from the pivot. There is only one '301' in the table. SQL won't duplicate a value...
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
October 26, 2008 at 4:13 am
Ross McMicken (10/26/2008)
Using NULL is a design flaw?
It's a relational theory issue and there are two sides to it. One says nulls are fine to indicate missing or unknown...
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
October 26, 2008 at 3:59 am
Can you explain in more detail?
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
October 26, 2008 at 3:45 am
Jeff Moden (10/25/2008)
Funny... on mine (Developer's editition, pre-sp1), recursive triggers was set to ON in 2k5 even after I installed sp2.
Check Model. It could be that at...
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
October 26, 2008 at 3:22 am
Viewing 15 posts - 43,546 through 43,560 (of 49,552 total)