Viewing 15 posts - 44,221 through 44,235 (of 49,571 total)
Matt Miller (9/25/2008)
GilaMonster (9/25/2008)
Matt Miller (9/25/2008)
On other (non-variable length) columns, such as int, the space is still allocated even when the Bit map is set.
I don't think they are. Will...
September 25, 2008 at 10:57 am
Robert klimes (9/25/2008)
Is there something that I am overlooking that is causing this, or do nulls take up some space?
Don't forget that the row headers and footers do take some...
September 25, 2008 at 10:48 am
But it's not going to be 42 GB for a million rows.
September 25, 2008 at 10:39 am
Arthur.Lorenzini (9/25/2008)
Doesn't creating the FK back it up with an index?
No. As I said, foreign keys are not indexes.
Primary keys are enforced by indexes, it's the only way to...
September 25, 2008 at 10:37 am
If you want someone to rewrite the query, you're going to have to help them.
Please give us the table structure (as create table statements), the index definitions (all of...
September 25, 2008 at 10:35 am
Use Jacob's version, it's faster than the convert to varchar and back. See my blog for the details.
And please don't shout at us. (post in all caps)
September 25, 2008 at 10:23 am
There's a post on Paul Randal's blog on how to 'hack' a corrupt DB back into a server after it was detached. It's one of the more recent entries.
http://www.sqlskills.com/blogs/paul
Also note...
September 25, 2008 at 10:21 am
Only in SQL 2008, and that's just a cpu-time and memory priority. If a kill command is issued against your session, it will be terminated.
I'm curious. Why do you need...
September 25, 2008 at 10:17 am
Have a look at the page in BoL titled "DDL Event Groups for Use with Event Notifications"
There are a few events there that aren't included in DDL triggers, but it...
September 25, 2008 at 10:13 am
Robert Davis (9/24/2008)
September 25, 2008 at 10:06 am
It's not a new data type. I know it's been around since 2000, I think it's been around much longer.
September 25, 2008 at 10:03 am
What's that query supposed to do?
How many rows are in those tables?
Can you post the table and index structures and some sample data please?
Why all the count distincts? They're very...
September 25, 2008 at 10:00 am
DonKo (9/25/2008)
September 25, 2008 at 9:57 am
Molly Cary (9/24/2008)
September 25, 2008 at 9:55 am
Jeff Moden (9/24/2008)
Yeah, but what does the OP want to do with it? 🙂
<shrug> Beats me. We'll probably never know
September 25, 2008 at 9:51 am
Viewing 15 posts - 44,221 through 44,235 (of 49,571 total)