Viewing 15 posts - 7,711 through 7,725 (of 49,552 total)
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
September 23, 2014 at 6:45 am
Thanks everyone. I was expecting massive disagreements, lots of shouting and insults. Pleasant surprise.
Davos, I would argue that you can approach performance tuning scientifically. No, it doesn't boil down to...
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
September 23, 2014 at 6:33 am
ashvindevil (9/23/2014)
I do not know why nolock hint has been used. Accurate result? What alternative do you propose?
Not using nolock? It's not a go-faster switch. It's a trade off 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
September 23, 2014 at 6:00 am
santoshkal (9/23/2014)
Its around 82 pages
Way too small to even bother trying to defragment.
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
September 23, 2014 at 5:58 am
santoshkal (9/23/2014)
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
September 23, 2014 at 5:58 am
Perry Whittle (9/23/2014)
Steve Jones - SSC Editor (9/6/2014)
I assume this is TDE, correct?No, the OP is using encrypted backups in 2014, it's a new feature
Where do you see that? OP...
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
September 23, 2014 at 4:34 am
Neither.
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
And why the nolock hint? Is accurate results not required from this query?
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
September 23, 2014 at 4:01 am
jacksonandrew321 (9/23/2014)
If I have to do encryption at object level then how can I proceed? Is it possible. Only I understand about the encryption is of theoretical.
There's no encryption 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
September 23, 2014 at 3:02 am
No, traceflag 1222 won't have noticable impact. But all that traceflag does is write deadlock graphs to the error log. Are you having deadlocks (batches failing with error 1205)?
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
September 23, 2014 at 2:51 am
The delay on first execution is unlikely to be the execution plan. Far more likely to be loading the data into cache. Plans just don't usually take that much time...
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
September 23, 2014 at 2:49 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Replies to http://www.sqlservercentral.com/Forums/Topic1618612-391-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
September 23, 2014 at 2:30 am
jacksonandrew321 (9/23/2014)
I mean if it is encrypted then it should ask for decryption while I used to open my database.
That's not what transparent database encryption does.
TDE protects the 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
September 23, 2014 at 1:32 am
You're missing the ON clauses.
FROM [BudgetFormulation].[dbo].[ObjectClass] obj
Left Join [BudgetFormulation].[dbo].[DIMObject] dobj ON <join condition>
Left Join [BudgetFormulation].[dbo].[DIMSTA] dsta ON <join condition>
And please, if you're going to...
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
September 22, 2014 at 3:12 pm
Check the connection string which the C++ app is using. The host name can be specified in the connection string.
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
September 22, 2014 at 3:10 pm
GilaMonster (9/22/2014)
The algorithm used for SQL logins isn't documented.
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
September 22, 2014 at 3:07 pm
Viewing 15 posts - 7,711 through 7,725 (of 49,552 total)