Viewing 15 posts - 29,161 through 29,175 (of 49,552 total)
It's the other SQL Server trying to get statistics info so that it can correctly estimate rows for query optimisation.
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
November 28, 2010 at 10:45 pm
Please note: Almost 3 year old thread.
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
November 28, 2010 at 10:43 pm
Adiga (11/28/2010)
Taking a FULL backup without a transaction log backup would cause the transaction log to grow.
No it won't. Taking a full backup, making changes to the database and not...
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
November 28, 2010 at 12:56 pm
Adiga (11/28/2010)
I suspect you would have scheduled a FULL backup for model database and there is no Transaction Log backup scheduled.
Recovery model not withstanding, model won't grow (data or log)...
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
November 28, 2010 at 11:07 am
If model is growing, someone or something is creating and using objects in it.
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
November 28, 2010 at 9:32 am
Well I don't know what you're doing, so I can't really advise you...
If you're trying to use dynamic SQL so that you can use the same trigger code on every...
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
November 28, 2010 at 9:30 am
The inserted and deleted tables are only visible within the trigger, not within anything it calls (including dynamic SQL)
I would strongly advise you against dynamic triggers. They look nice, but...
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
November 28, 2010 at 6:14 am
Sqlsavy (11/28/2010)
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
November 28, 2010 at 6:06 am
george sibbald (11/28/2010)
USe with norecovery NOT no_truncate to do a tail log backup.
Err....
WITH NORECOVERY is for when the database is online and available, it's for taking that last log...
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
November 28, 2010 at 6:04 am
You check through the RAID logs, SAN logs (whichever is applicable), application logs, system logs and look for anything that looks like an IO error. You ask your system admins...
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
November 28, 2010 at 5:58 am
No and No.
There's a command to rebuild all the indexes on a table. Doing a rebuild on every single index of every single table is, quite honestly, something you don't...
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
November 27, 2010 at 1:54 am
Nils Gustav Stråbø (11/26/2010)
reading the same row twice can also happen with read committed.
True, but you need more specific circumstances than with read uncommitted. There are allowed anomalies in every...
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
November 27, 2010 at 1:48 am
CELKO (11/26/2010)
Older, experienced SQL programmers use the original syntax so they can see n-ary relationships.
An unfounded generalisation of monumental proportion. Opinion. Blatantly wrong in a vast number of cases.
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
November 27, 2010 at 1:30 am
Shawn Melton (11/26/2010)
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
November 26, 2010 at 12:35 pm
The old style joining in where clause is only deprecated (and in fact removed) for outer joins. The inner join in where clause is still fully supported and is not...
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
November 26, 2010 at 12:32 pm
Viewing 15 posts - 29,161 through 29,175 (of 49,552 total)