Viewing 15 posts - 2,986 through 3,000 (of 18,926 total)
What version are you using? Shouldn't happen after 2k!
September 7, 2011 at 6:12 am
Can you post more details? Over 50 views already and no answers... not normal here.
September 7, 2011 at 6:05 am
Try putting a clustered PK on the identity colum and see if that fixes it. Heap "index" could be the source of your problems.
September 7, 2011 at 5:58 am
Get ready for fireworks, a "newbie" basically just told CELKO to shove it. Can't wait to see his reply!
http://www.sqlservercentral.com/Forums/Topic1170719-392-1.aspx#bm1170830
September 7, 2011 at 5:55 am
You can't use order by at the union all level, it must be after...
SELECT * from master.sys.columns
UNION ALL
SELECT * FROM msdb.sys.columns
--the union all is now formed into a single dataset
ORDER...
September 6, 2011 at 2:38 pm
GSquared (9/6/2011)
Have you run a trace to see what the commands are?Have you thought about setting the default isolation level to READ_COMMITTED_SNAPSHOT? (Data here: http://msdn.microsoft.com/en-us/library/ms173763.aspx)
Those commands are run...
September 6, 2011 at 2:29 pm
Yes it was quite amazing. There was 100 low hanging fruits and I picked them all in not time flat (using Gail's article).
My favorite was SELECT MAX(INT COL) +...
September 6, 2011 at 2:25 pm
Jeff Moden (9/6/2011)
Roy Ernest (9/6/2011)
Yay...!!! I beat the THREAD to the landmark. I hit 3000 posts before the thread hit 3000 pages. 🙂
I was going to post a prediction that...
September 6, 2011 at 2:20 pm
LutzM (9/6/2011)
Ninja's_RGR'us (9/6/2011)
...Here's the full album from that day! Enjoy and dream on!
http://s1123.photobucket.com/albums/l551/Ninja_RgRus/Sunrise%20August%2023rd%202011/
Do you know it seems like you're living in a place others would pick for vacation?...
September 6, 2011 at 2:17 pm
GilaMonster (9/6/2011)
Roy Ernest (9/6/2011)
Yay...!!! I beat the THREAD to the landmark. I hit 3000 posts before the thread hit 3000 pages. 🙂
Congrats.
Easy to beat the thread's page count. Just change...
September 6, 2011 at 2:15 pm
Perry Whittle (9/6/2011)
Ninja's_RGR'us (9/6/2011)
Can you ballpark the amount of time required to learn + install?
you dont want to learn all the clustering stuff, etc. You just want to install VMWare...
September 6, 2011 at 10:49 am
Can you ballpark the amount of time required to learn + install?
September 6, 2011 at 10:42 am
Perry Whittle (9/6/2011)
Here you gohttp://www.sqlservercentral.com/articles/virtual/72682/[/url]
Tx, will check it out later this week.
PS, I love how part 2 of the article links to part 2 of the article instead of part...
September 6, 2011 at 10:41 am
Cadavre (9/6/2011)
September 6, 2011 at 10:10 am
Can't turn off the logs (as in impossible)
Even in simple mode the logs will get full.
As I said you can add another log file on another drive where you have...
September 6, 2011 at 10:06 am
Viewing 15 posts - 2,986 through 3,000 (of 18,926 total)