Viewing 15 posts - 7,711 through 7,725 (of 49,571 total)
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...
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...
September 23, 2014 at 6:00 am
santoshkal (9/23/2014)
Its around 82 pages
Way too small to even bother trying to defragment.
September 23, 2014 at 5:58 am
santoshkal (9/23/2014)
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...
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?
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...
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)?
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...
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
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...
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...
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.
September 22, 2014 at 3:10 pm
GilaMonster (9/22/2014)
The algorithm used for SQL logins isn't documented.
September 22, 2014 at 3:07 pm
Viewing 15 posts - 7,711 through 7,725 (of 49,571 total)