Viewing 15 posts - 6,136 through 6,150 (of 49,571 total)
If you're getting stack dumps from Access Violations, I would suggest you open a case with Microsoft's customer support people.
April 20, 2015 at 3:57 am
coetzeehuman (4/20/2015)
Remember that converting on joins means it does row based joins and not data set based joins
No, it just means that indexes aren't of any use to the join...
April 20, 2015 at 2:51 am
imsqldba007 (4/17/2015)
Could you please some one share Clustering,mirroring and logshipping real time interview questions
Tell me of a time when you implemented clustering, mirroring or log shipping. What problems did you...
April 20, 2015 at 2:38 am
keshab.basnet (4/19/2015)
Also could you please suggest me right time to shrink log file.
Never.
Please have a read through the book mentioned above
April 20, 2015 at 2:35 am
The default trace does log temp table creates and drops.
April 20, 2015 at 2:33 am
It's Service Broker, but there's not that much more of use. You're going to have to debug Service Broker and figure out why it's throwing errors. Certificates in database 9...
April 20, 2015 at 2:31 am
Could you please post the execution plan from the database which has the poor performance? It really doesn't help to see how SQL runs the query against a small data...
April 17, 2015 at 10:10 am
andrew gothard (4/17/2015)
But, hooray, you can snapshot a database and check that. All 2 Tb of it, why thank you for that, not helpful.
I'm not sure why that's not...
April 17, 2015 at 10:09 am
To be blunt, you probably aren't going to be able to do that.
The linkage is downwards. The data pages link to the text pages (and there can be multiple), there...
April 17, 2015 at 10:06 am
It runs for 8 seconds in the database where you captured that execution plan?
April 17, 2015 at 9:17 am
Not a picture of the execution plan. The saved execution plan. The picture is missing all the important information.
April 17, 2015 at 8:56 am
If you mean the files, either. Either different names in the same folder as the other DBs or change the location. Doesn't matter, the point is that you don't want...
April 17, 2015 at 8:33 am
You restore backups, you can't attach a backup.
In the restore dialog, just make sure that the DB is restoring to a new name and make sure the files get different...
April 17, 2015 at 8:25 am
You can restore a backup as a different database very easily. In the GUI just make sure that the DB is restoring to a different name and make sure the...
April 17, 2015 at 8:08 am
Table definitions, index definitions and execution plan please?
April 17, 2015 at 8:07 am
Viewing 15 posts - 6,136 through 6,150 (of 49,571 total)