Viewing 15 posts - 751 through 765 (of 1,193 total)
vahid.arr (10/9/2012)
October 9, 2012 at 3:37 am
terry999 (10/2/2012)
illegal?
Hmm, yeah. Was wondering that myself!
October 9, 2012 at 3:29 am
Lokesh Vij (10/9/2012)
Gazareth (10/9/2012)
Nils Gustav Stråbø (10/9/2012)
Lokesh Vij (10/9/2012)Here you go:
Won't work. Only one table at the time can have IDENTITY_INSERT OFF
Only one table at the time can have IDENTITY_INSERT...
October 9, 2012 at 3:26 am
Nils Gustav Stråbø (10/9/2012)
Lokesh Vij (10/9/2012)Here you go:
Won't work. Only one table at the time can have IDENTITY_INSERT OFF
Only one table at the time can have IDENTITY_INSERT ON.
I don't think...
October 9, 2012 at 3:13 am
Thanks, good question. Actually guessed at the answer (hoped the specific versions mentioned was a clue), but it's taught me something I didn't know!
It is interesting that it's been implemented...
October 9, 2012 at 2:51 am
Perry Whittle (10/8/2012)
I'm still learning at the mo, got myself a nice set of second hand Ping Eye 2 irons and Callaway ERC Fusion woods 🙂
Nice! Having lessons or going...
October 8, 2012 at 7:41 am
SQLRNNR (10/5/2012)
I caught some of it. Recorded some it. Was gravely disappointed that they couldn't hold on to that lead.
Pretty much no-one saw it coming! Thought the European...
October 8, 2012 at 4:36 am
Old threads don't die, they just get flushed to disk...
October 5, 2012 at 9:30 am
SQLBill (10/4/2012)
Just saw this thread....I golf (I live in Arizona where there are lots of courses)...but I don't watch any golfing. Almost as boring to watch as tennis.-SQLBill
Ha, you...
October 5, 2012 at 9:25 am
You could also look into starting sql server in minimal configuration mode (-f switch).
This may allow you to get to a point where you can reissue the ALTER DATABASE commands...
October 5, 2012 at 3:50 am
You can type number values directly into the min, max, and interval boxes for the chart.
However if different report runs require different ranges, you'll have to do something fancy with...
October 5, 2012 at 3:06 am
No worries, was wondering if you'd done something like that, or used the in-built SSRS behaviour, which does as I described.
I've also had success using temp tables the other way...
October 4, 2012 at 6:11 am
Hi,
How does the report perform if you remove the part of the WHERE clause that references the MVP?
If it's much quicker, my way would be to get the data into...
October 4, 2012 at 3:23 am
Hi Jason,
Looks fine to me.
Is this for multiple queries? The MAX_DOP setting in CREATE WORKLOAD GROUP should prevent individual queries running on more than 2 processors, but multiple queries don't...
October 3, 2012 at 9:31 am
Viewing 15 posts - 751 through 765 (of 1,193 total)