Viewing 15 posts - 6,736 through 6,750 (of 49,552 total)
https://www.google.co.za/?q=SQL+Server+2014+new+features
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
January 21, 2015 at 6:32 am
Maybe, maybe not. No hard answer there. Depends if you're seeing IO contention or not. If not, then splitting them out is a huge amount of work for minimal gain.
Deletes...
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
January 21, 2015 at 2:44 am
No, not unless the file groups in question are read only.
To restore a DB from file/filegroup backups, the following is required:
1) If the DB is in simple recovery, then any...
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
January 21, 2015 at 2:07 am
I'm going to assume by that question that you don't have a backup.
If you do have a backup you can restore, please rather do that.
The hack is on Paul...
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
January 21, 2015 at 1:52 am
WhiteLotus (1/20/2015)
How do I measure the Duration ( using SQL Profiler ) of that INSERT ?
Same way as any other statement. There's nothing special about inserts
if I run 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
January 21, 2015 at 1:46 am
lmarkum (1/20/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
January 21, 2015 at 1:41 am
With a single select it's not necessary. With multiple selects, if you're running under the default isolation level then the transactions don't change anything about how the selects behave, in...
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
January 21, 2015 at 1:36 am
Eric M Russell (1/20/2015)
which is ok so long as underscores are also used for clarity.
Underscores?!?!?! Heretic! Burn him!
:hehe:
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
January 20, 2015 at 12:13 pm
Can you restore a backup?
If so, do so.
If not, you'll have to hack the DB into the server and repair it, you may lose data, you may lose...
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
January 20, 2015 at 12:11 pm
Ok, not an SSMS version mismatch.
Offhand, not sure. Have you tried doing the mirroring setup in T-SQL instead of the GUI?
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
January 20, 2015 at 7:19 am
And the results of SELECT @@Version on both principal and mirror?
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
January 20, 2015 at 6:53 am
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
January 20, 2015 at 5:59 am
I use ID, everyone else in my company uses Id.
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
January 20, 2015 at 5:29 am
Huh?
Don't understand the question.
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
January 20, 2015 at 5:29 am
Those 4 exams are for two different certifications, so which you take depends on which certification you want.
There's no higher certification level than the MCSE.
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
January 20, 2015 at 5:28 am
Viewing 15 posts - 6,736 through 6,750 (of 49,552 total)