Viewing 15 posts - 6,136 through 6,150 (of 49,552 total)
If you're getting stack dumps from Access Violations, I would suggest you open a case with Microsoft's customer support people.
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
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...
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
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...
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
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
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
April 20, 2015 at 2:35 am
The default trace does log temp table creates and drops.
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
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...
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
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...
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
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...
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
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...
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
April 17, 2015 at 10:06 am
It runs for 8 seconds in the database where you captured that execution plan?
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
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.
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
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...
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
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...
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
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...
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
April 17, 2015 at 8:08 am
Table definitions, index definitions and execution plan please?
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
April 17, 2015 at 8:07 am
Viewing 15 posts - 6,136 through 6,150 (of 49,552 total)