Viewing 15 posts - 3,901 through 3,915 (of 49,552 total)
Ed Wagner (1/5/2016)
With it being for SQL 2016 though, I know it'll be several years before I can use it.
Nope, you can go and download it now and start using...
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 5, 2016 at 5:59 am
In my experience, the 0% complete, 0 seconds remaining rollbacks tend to sit around forever. It would be waiting for an external resource, so do check, but those ones alone...
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 5, 2016 at 2:47 am
Are you still getting the error after CheckDB ran?
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 5, 2016 at 2:31 am
roger.plowman (1/4/2016)
SQL, on the other hand, makes it hard to *avoid* accidental code execution inside parameters...
It's not hard at all.
Always parameterise queries (no, stored procs aren't required, parameterised SQL...
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 4, 2016 at 6:57 am
One way, if the resultset it not too large, pull the entire thing to the client and do the paging in the grid. Advantage there is that 'next' is fast...
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 4, 2016 at 3:54 am
And for interest sake, using NewID() which really is evaluated on every row, the average CPU and duration with the same test setup:
CPU: 936
Duration: 927.8
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 4, 2016 at 3:48 am
Alex Gay (1/4/2016)
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 4, 2016 at 3:39 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 2, 2016 at 11:58 am
Tac11 (12/31/2015)
One more question, which option is better?
Both. Neither.
As with all index-related questions, it completely depends on the queries running against the table. If you have queries that filter on...
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
December 31, 2015 at 11:19 am
Already home.
The CEO left about 2:30, and encouraged everyone who was still there to leave as well. No plans for the evening, so I think I'll play Kerbal Space...
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
December 31, 2015 at 7:06 am
That's an irreparable error. You'll need to restore from your last good backup to fix that.
PFS and other allocation pages cannot be single-page restored, you'll need to restore the entire...
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
December 31, 2015 at 2:23 am
Why are you partitioning? What's the goal?
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
December 30, 2015 at 2:55 pm
https://www.google.com/?q=SQL+Server+2014+changes+to+the+cardinality+estimator
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
December 30, 2015 at 2:54 pm
No.
Active-active is a not the same instance and same databases on both nodes. It should be called 'multi-instance clustering', and it's when you have Instance1 with DatabaseA, DatabaseB on node...
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
December 30, 2015 at 6:22 am
No.
Temp tables are dropped when the scope they're created in ends, and that's the dynamic SQL. The temp table is created, but is dropped when the dynamic SQL ends. 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
December 30, 2015 at 6:00 am
Viewing 15 posts - 3,901 through 3,915 (of 49,552 total)