Viewing 15 posts - 4,111 through 4,125 (of 49,552 total)
We can compensate for badly written code with more badly written code. Excellent plan.
Correctly terminate all statements with a semicolon (they're statement terminators). The end.
If someone did not correctly...
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 2, 2015 at 8:12 am
xsevensinzx (12/2/2015)
Don't forget to put it at the beginning of each CTE too.
!Gah !No
.A semicolon is a statement *terminator* .It is not something that gets placed at the beginning of...
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 2, 2015 at 6:29 am
Then you may just have to re-implement the code from Proc 1.
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 2, 2015 at 4:28 am
ravi@sql (12/2/2015)
yes you can, but how will you do that ?
In procedure 1, create three temp tables. In procedure 2, insert into those temp tables. Back in Procedure 1, use...
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 2, 2015 at 4:02 am
Justin Manning SA (12/2/2015)
Could you store them in a table variable?
It would need to be a temp table, because table variables have a scope of the current procedure 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
December 2, 2015 at 4:01 am
You can't change the default trace.
What you can do is turn the default trace off and create your own trace which logs what you want. I recommend using Extended...
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 2, 2015 at 3:50 am
TomThomson (12/1/2015)
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 2, 2015 at 3:13 am
Caching's typically done either in the application server or a cache between the app server and the DB. Caching's not something you can just plug in and go, you need...
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 2, 2015 at 3:09 am
To be honest, I'd suggest debugging the backup solution. Transfer's not something that I'd recommend using except for downgrading a database. It's also a lot slower than backup/restore (it scripts...
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 2, 2015 at 2:12 am
You'll probably find the time difference to be utterly meaningless and under the error range for measuring duration of statements. Worrying about a couple microseconds here or there is likely...
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 2, 2015 at 2:04 am
shamshad.ali (12/2/2015)
Do you want me to add another index non clustered (Detail.Id, Detail.MasterId)?
No.
I said if there is no existing index on the Detail table on MasterID, create one on...
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 2, 2015 at 1:59 am
Ok, so either run the purging in quieter times, or in smaller chucks or fix the query and indexing problems that's causing queries to be slow.
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 2, 2015 at 1:55 am
Ah, I thought it was the other way around. Ignore them (they're harmless except for causing checkDB to fail) or rebuild the DB (script, export, recreate).
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 1, 2015 at 2:04 pm
What object has an ID of 12331604?
And check all the other IDs being reported from CheckDB too.
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 1, 2015 at 1:30 pm
If the trace shows it's coming from SQL, then it's coming from SQL. It's not bogus, the trace is telling you what application name the client is passing. Is there...
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 1, 2015 at 1:29 pm
Viewing 15 posts - 4,111 through 4,125 (of 49,552 total)