Viewing 15 posts - 21,451 through 21,465 (of 39,961 total)
Force, ha! I'm powerful in the ways of the word, or at least keyboard in this universe website.
Broken images came about as we upgraded servers yesterday. Finally, we got the...
December 18, 2009 at 7:21 am
I'm not sure I'd agree that SS2K5 was built to sell VS. It was a good product, groundbreaking for SQL Server in terms of growing the product. Adding in Service...
December 18, 2009 at 7:15 am
user_name()
suser_sname()
There are a few functions, depends on what you want to capture.
December 17, 2009 at 6:03 pm
wow, you guys are really splitting hairs. A restart includes a shutdown and startup of the database instance. How could you argue it includes anything else? In line with a...
December 17, 2009 at 3:42 pm
I had the chance to tour Falling Water in 98, and heard about a number of the issues that came about over time. It is an amazing structure and this...
December 17, 2009 at 9:46 am
John McC (12/17/2009)
I didn't pick 1 because isn't the table dropped when the instance is shutting down as opposed to restarting (picky I know but...)
A restart includes a shutdown and...
December 17, 2009 at 9:07 am
I would agree that #2 is a little incomplete. That answer has been edited and points are being awarded back to everyone that has answered to date.
December 17, 2009 at 9:06 am
Thanks, and you two are probably two of those "successful" people because of your principles.
December 17, 2009 at 7:26 am
Even with this, I'd argue you won't know.
If I update row 12 now and you update row 16 in a minute, we'll only see the last update (row 16)....
December 16, 2009 at 12:55 pm
Take Grant's suggestion and create a CTE to hold the data and use that in your joins.
December 16, 2009 at 9:08 am
Speaking of funny looking, I got a "twas the night before Christmas" for next Thursday. I now need to go find an ugly Christmas sweater and a Santa hat.
December 16, 2009 at 9:07 am
I assume you've been through the "What's New"? http://msdn.microsoft.com/en-us/library/bb386063.aspx
Fundamentally I'm not sure there are things you "need" in VS 2008. You could get a trial and see if you see...
December 16, 2009 at 9:05 am
Sorry, Bru, I removed the other post. I'll edit yours.
The DTC service ensures that a transaction that crosses two servers, say an insert, actually completes on both servers. There are...
December 16, 2009 at 9:00 am
An ER diagram is typically built to show the relationships in the tables. If you have those tables, those are what would appear in the ER diagram and be related...
December 16, 2009 at 8:58 am
Log shipping is strictly a
- log backup
- network file copy
- log restore
While SQL Server can secure communications, it doesn't secure the file copy. That's a windows function. You'd need to...
December 16, 2009 at 8:53 am
Viewing 15 posts - 21,451 through 21,465 (of 39,961 total)