Viewing 15 posts - 3,076 through 3,090 (of 49,571 total)
Please note: 4 year old thread.
dbf files aren't SQL Server files either.
May 13, 2016 at 4:21 am
Brandie Tarvin (5/12/2016)
I read the article, read the comments and was nearly floored by the assumption that any DBA could afford the $20k to sit the lab exam.
1) It wasn't...
May 12, 2016 at 10:36 am
BLOB_EATER (5/12/2016)
Really enjoying the article and the comments, shame the connect article has now gone.
The connect item was taken down by the person who had initially posted it, as it...
May 12, 2016 at 6:16 am
BLOB_EATER (5/12/2016)
GilaMonster (5/12/2016)
BLOB_EATER (5/12/2016)
May 12, 2016 at 4:12 am
BLOB_EATER (5/12/2016)
Don't...
May 12, 2016 at 3:38 am
The problem with 64 is finding a desktop motherboard that will support it. Most only have 4 memory slots, so you're looking at 16GB dimms, those aren't cheap and you...
May 11, 2016 at 8:09 am
Select some DATEADD columns from a table is complex?
There's many more complex methods, but some form of tally table's probably one of the easiest.
May 11, 2016 at 8:07 am
Huh?
Graphics card doesn't have anything to do with memory.
If the motherboard has a built-in graphics card, then you can use that, the on-board stuff is fine for most non-gaming...
May 11, 2016 at 6:23 am
Lowell (5/10/2016)
would anyone agree zero seeks implies the clustered index should probably be moved to something that satisfies more of the queries that are actually in use?
Maybe, but depends on...
May 11, 2016 at 4:06 am
Eirikur Eiriksson (5/10/2016)
One could argue that 153000 userlookups indicates that other indices should be created, key lookup is quite expensive operation.
Since key lookups are only ever done to the clustered...
May 11, 2016 at 4:05 am
To get them to execute in parallel, you need 40 separate connections, however you generate them. Jobs, application, etc.
May 11, 2016 at 3:59 am
Eric M Russell (5/10/2016)
You'll probably see no performance improvement by placing the table on a RAM disk.
I would agree with this.
The performance improvements from Hekaton don't come from the...
May 11, 2016 at 3:55 am
I wouldn't recommend it. Fixing the query plans means that when the data changes, the optimiser can't choose a better option. While it might save time now, it'll mean more...
May 11, 2016 at 3:52 am
Run
RESTORE DATABASE <database name> WITH RECOVERY
May 11, 2016 at 3:43 am
What have you tried so far? Where are you stuck?
This looks suspiciously like homework, and you won't learn anything by having someone write the code for you.
May 10, 2016 at 6:21 am
Viewing 15 posts - 3,076 through 3,090 (of 49,571 total)