Viewing 15 posts - 3,901 through 3,915 (of 49,571 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...
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...
January 5, 2016 at 2:47 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...
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...
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
January 4, 2016 at 3:48 am
Alex Gay (1/4/2016)
January 4, 2016 at 3:39 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...
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...
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...
December 31, 2015 at 2:23 am
Why are you partitioning? What's the goal?
December 30, 2015 at 2:55 pm
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...
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...
December 30, 2015 at 6:00 am
Viewing 15 posts - 3,901 through 3,915 (of 49,571 total)