Viewing 15 posts - 16,051 through 16,065 (of 39,824 total)
Short answer, test. Not sure how the 32 bit drivers will work, but I'd install them on a x64 instance and see if you can access things. There is a...
May 16, 2011 at 9:24 am
That's like saying it took me 2 hours to get to work yesterday but it normally takes me 1 hour. Why?
There's no way we can know what took longer. Can...
May 16, 2011 at 9:22 am
Always go downstream first, since the update could change the db version. Things are usually backwards compatible, not forward. So log shipped receivers first, then live servers.
Replication: Do you mean...
May 16, 2011 at 9:21 am
Is this a one time thing or a regular occurrence? If it's regular, have you looked at DTS? You can use the Import wizard from EM to create a package...
May 16, 2011 at 9:14 am
If you have an active connection, you can open all of them without issue. Is there a reason you can't make one connection and leave it open?
May 16, 2011 at 9:11 am
I think that's it. It's a verification of the creator/author of the assembly.
May 16, 2011 at 9:10 am
Deletes are deferred, with the rows "marked" as deleted and then the ghost cleanup task running later. So if you delete something and check space immediately, it will not appear.
Second,...
May 16, 2011 at 9:09 am
I think I use varchar(250) for mine.
Ultimately there is no difference to SQL Server if it's varchar(36) or varchar(1000) other than what the upper limit is for entries. Go large,...
May 16, 2011 at 9:06 am
It's not quite clear, perhaps from the formatting, or from the description what you mean. Can you specifically list which column you are outputting and where and how it is...
May 16, 2011 at 9:00 am
UMG Developer (5/13/2011)
Steve,
If you lookup may in a dictionary you will notice that item 4 is: "shall, must —used in law where the sense, purpose, or policy requires this interpretation."
So...
May 16, 2011 at 8:54 am
michael.kaufmann (5/16/2011)
I'm even more confused now ... :w00t:
The edited correct answer reads:
[...] Rows CAN span multiple pages.
[...] Ref: Pages and Extents - http://msdn.microsoft.com/en-us/library/ms190969.aspx Rows CANNOT span pages
BOL is wrong on...
May 16, 2011 at 8:50 am
dduensing (5/16/2011)
May 16, 2011 at 8:45 am
Brandie Tarvin (5/13/2011)
I thought I wrote it as "data pages". Didn't I?
Perhaps. I think I altered it since the LOB data part wasn't included. Data could include LOB.
I think it...
May 13, 2011 at 9:35 am
SQLkiwi (5/13/2011)
Steve Jones - SSC Editor (5/13/2011)
Comments encouraged on the changes.
"Extents may be owned by only one object".
This still reads (to me) as excluding the possibility that an extent may...
May 13, 2011 at 9:33 am
Paul Randal (5/13/2011)
May 13, 2011 at 9:30 am
Viewing 15 posts - 16,051 through 16,065 (of 39,824 total)