Viewing 15 posts - 43,576 through 43,590 (of 49,571 total)
There is no way you're going to be able to get that result straight from the pivot. There is only one '301' in the table. SQL won't duplicate a value...
October 26, 2008 at 4:13 am
Ross McMicken (10/26/2008)
Using NULL is a design flaw?
It's a relational theory issue and there are two sides to it. One says nulls are fine to indicate missing or unknown...
October 26, 2008 at 3:59 am
Jeff Moden (10/25/2008)
Funny... on mine (Developer's editition, pre-sp1), recursive triggers was set to ON in 2k5 even after I installed sp2.
Check Model. It could be that at...
October 26, 2008 at 3:22 am
How many pages?
As I said, smaller tables will not have fragmentation reduced to 0, and it's nothing to be concerned about
October 26, 2008 at 3:18 am
It has to do with how the first few pages of the table are allocated. How many pages are there in this table?
October 25, 2008 at 3:27 pm
How big is the table, how many rows, how many pages? (sys.dm_db_index_physical_stats will tell you that)
If I had to guess, I'd say this is a really small table, less than...
October 25, 2008 at 2:43 pm
Jeff Moden (10/21/2008)
October 25, 2008 at 2:36 pm
Andy Leonard (10/25/2008)
Technically, I grew up here (at SSC).
Likewise. I found this site when I was just getting started with SQL. Initially it was the question of the day that...
October 25, 2008 at 11:19 am
Grant Fritchey (10/25/2008)
October 25, 2008 at 6:00 am
You have to aggregate, but what you can do is to add a fake column in which you then ignore.
This more or less gets want you want. I don't understand...
October 25, 2008 at 5:57 am
Here's a schedule for all the SQL 2008 exams:
http://blogs.msdn.com/gerryo/archive/2008/10/24/weekly-exam-status-update.aspx
October 25, 2008 at 3:20 am
Can you please post some sample data and your desired output.
October 25, 2008 at 3:01 am
Jeff Moden (10/24/2008)
October 25, 2008 at 2:56 am
On my 2008 box, it varies. First one is faster then the other, but it's a difference of around 20ms over 1000000 executions, So works out at about 20 nanoseconds...
October 25, 2008 at 2:54 am
Viewing 15 posts - 43,576 through 43,590 (of 49,571 total)