Viewing 15 posts - 28,801 through 28,815 (of 49,552 total)
Please post your question in a new thread and include the query, table definitions, index definitions and execution plan.
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
December 20, 2010 at 1:37 pm
Pei Zhu-415513 (12/20/2010)
If the database is simple/or bulk logged database, will the minimally logged activities such as rebuild indexes be replicated to subscribers?
Those aren't replicated regardless of the recovery model.
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
December 20, 2010 at 1:35 pm
vino5786 (12/20/2010)
through stored procedures...
Then there's no problem here. When you put this into a stored proc, make those parameters of the proc and you'll get the same behaviour as 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
December 20, 2010 at 1:34 pm
gmamata7 (12/20/2010)
The database is backing up to local disk (clustered disk) only. But the job step requires the backup path should be in the format of network share.
What are you...
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
December 20, 2010 at 1:33 pm
Look up ALTER DATABASE. It's done the same as for any user databases.
p.s. typically secondary data files have the .ndf extension, not .mdf. That's just convention though.
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
December 20, 2010 at 4:08 am
How is this query getting called from your front end application?
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
December 20, 2010 at 3:29 am
The Row_Number function will do what you want. First write a select that returns the data you what, then use that in the from clause of the update.
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
December 20, 2010 at 12:57 am
Probably a temporary network glitch. SQL won't retry if the network drops. That's one reason the usual recommendation is to backup locally then copy the backup files across the network....
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
December 20, 2010 at 12:57 am
Did someone restart the principal? In recovery means SQL's doing crash recovery on the database, it shouldn't take long in most cases. Check the SQL error log for any messages...
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
December 20, 2010 at 12:55 am
Low Rider (12/19/2010)
Now looking at the second line what exactly is the kind of data is being written to the disk withouth 1st going to the t-log.
None. No dirty 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
December 19, 2010 at 10:39 pm
Spam. Reported. No replies please.
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
December 19, 2010 at 9:01 am
That command clears the sys.dm_os_wait_stats DMV. It does not clear the current waits in sys.dm_exec_requests.
You haven't said, but I'm willing to guess those are system processes, hence ones you...
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
December 19, 2010 at 1:36 am
http://sqlinthewild.co.za/index.php/2008/12/05/a-new-sql-myth/
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
December 19, 2010 at 1:34 am
Don't understand what you're asking. Please clarify.
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
December 18, 2010 at 2:45 pm
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
December 18, 2010 at 2:43 pm
Viewing 15 posts - 28,801 through 28,815 (of 49,552 total)