Viewing 15 posts - 16 through 30 (of 61 total)
red_serene (7/26/2009)
I believe that the answer to this topic is incorrect. Per the above URL for sql2008, both Enterprise and Standard editions support Snapshot Replication. As Developer and...
July 27, 2009 at 6:02 am
dbaker (7/23/2009)
would be better NOT to use the sp_ prefix !
Strongly agreed. If you do not intend to put a stored procedure in the master database (which should not be...
July 23, 2009 at 6:03 am
It would have been interesting to see the results if there was a third choice "False, the table has to be dropped and recreated with the column assigned the new...
July 23, 2009 at 5:46 am
Same here, no images, just the red x in a box.
July 20, 2009 at 6:14 am
Derek the robot will do DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS in the next strip, just to be sure his work is done.
July 15, 2009 at 4:59 pm
Probably a fair number of lucky guesses from anyone who remembers using ARIMA for time series in their stats courses.
July 15, 2009 at 4:55 pm
I imagine a lot of people have been thinking about the feasibility of cloud computing given that even the "has worked fairly well" concept of web hosting has been shaken...
July 13, 2009 at 5:41 am
Thanks Phil, I thought the comparison to the Patriots was overblown. The Patriots wanted to freedom from a tyrannical system that was improper under any condition. The NoSQL crowd just...
July 11, 2009 at 1:40 pm
From slashdot yesterday, here's someone who does not have an ideal job. In addition to working a 12 hour shift, this person lives 1.5 hours from work.
http://ask.slashdot.org/story/09/07/01/190236/Staying-In-Shape-vs-a-Busy-IT-Job-Schedule
July 2, 2009 at 5:56 am
That's not an unreasonable list, I have quite a few of those at a small US firm now... however enough salary to retire by 50 is not one of them!
I...
June 29, 2009 at 5:34 am
I'm with David, the use of two rightmost strings in the COALESCE function doesn't make sense. You'll never get to the last (third) parameter. With COALESCE only the last (rightmost)...
June 26, 2009 at 6:59 am
ps (6/23/2009)
see if this helps uhttp://www.sqlteam.com/article/osql-storing-result-of-a-stored-procedure-in-a-file%5B/url%5D
Note that the technique in that article uses osql, which is a deprecated utility that will be removed from SQL Server, so...
June 23, 2009 at 7:38 am
Tao Klerks (6/23/2009)
Does anyone know whether the fact that disabling an index on an indexed view deletes the index data is noted anywhere in books online?
It's in the third...
June 23, 2009 at 5:51 am
Good article Jonathan, I've used these steps to move databases to new hardware and datacenter with just a few minutes of downtime. The key is making sure that the application(s)...
June 18, 2009 at 6:59 am
ta.bu.shi.da.yu (6/18/2009)
Ah... but how would you get around that? Is there any way of disabling the rounding?
You could use SET NUMERIC_ROUNDABORT ON to get an error instead of a rounded...
June 18, 2009 at 5:56 am
Viewing 15 posts - 16 through 30 (of 61 total)