Viewing 15 posts - 47,011 through 47,025 (of 49,552 total)
Ok, I haven't looked at the entire plan in detail (it's huge)
Here are some very quick index suggestions. Try them out, but no guarentees.
I don't know what indexes...
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
April 3, 2008 at 12:35 am
Databases don't have passwords.
You give credentials at the server level and then set the rights those credentials have for each database.
It's not too hard a process using Object Explorer.
Create...
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
April 2, 2008 at 11:54 pm
Please don't cross post. It just wastes people's time. Most of us read all the forums.
Please do not reply to this thread. Replies to the following thread please.
http://www.sqlservercentral.com/Forums/Topic478901-150-1.aspx
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
April 2, 2008 at 11:47 pm
You can set up a job if you want it to run at a particular time. If you just want 1 proc to call the rest, you can use xp_cmdshell...
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
April 2, 2008 at 11:43 pm
Please don't cross post. It just wastes people's time.
Please do not reply to this thread. All replies to the following please -
http://www.sqlservercentral.com/Forums/Topic478926-169-1.aspx
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
April 2, 2008 at 11:40 pm
Please don't cross post. It just wastes people's time.
Please do not reply to this thread. All replies to the following please -
http://www.sqlservercentral.com/Forums/Topic478926-169-1.aspx
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
April 2, 2008 at 11:40 pm
Michal Mokros (4/2/2008)
:Wow:That is exactly what I need!
Thanks
Just bear in mind, as I mentioned earlier, that the estimated execution plan is just that. Estimated.
There's no guarentee that the estimated cost...
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
April 2, 2008 at 6:52 am
SQL 2005?
If so, check the error log, see if there are any messages about teh backup buffer size been reduced.
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
April 2, 2008 at 4:58 am
Use varchar. Max of 8000 characters
Use multiple variables and concatinate them.
If you show us the code, we can help you more.
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
April 2, 2008 at 4:42 am
Try SET SHOWPLAN_XML ON, then run the query. It should return the xml as a resultset.
Make sure you switch the Showplan option off, as it will affect all statements run...
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
April 2, 2008 at 4:12 am
Just the system databases? Interesting. Master, Model and MSDB all giving the same error?
Are the user databases on a different drive?
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
April 2, 2008 at 3:37 am
Sandy (4/2/2008)
Can any body clear me how many characters allowed in varchar(8000) and nvarchar(4000)?
VARCHAR(8000) = 8000 characters.
NVarchar(4000) = 4000 characters (each taking 2 bytes)
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
April 2, 2008 at 3:24 am
You can use the estimated execution plan. Just bear in mind it is an estimate. If you're running into parameter sniffing problems (which from the sound of things you might...
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
April 2, 2008 at 2:12 am
And you can use sp_helptext to get their definition as well.
EXEC sp_helptext 'sys.objects'
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
April 2, 2008 at 1:50 am
Could you check the windows event log please? See if there are any errors in there from around the time of the DBCC. Check the system and application logs.
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
April 2, 2008 at 1:43 am
Viewing 15 posts - 47,011 through 47,025 (of 49,552 total)