Viewing 15 posts - 3,076 through 3,090 (of 49,552 total)
Please note: 4 year old thread.
dbf files aren't SQL Server files either.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2016 at 6:16 am
BLOB_EATER (5/12/2016)
GilaMonster (5/12/2016)
BLOB_EATER (5/12/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2016 at 4:12 am
BLOB_EATER (5/12/2016)
Don't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 11, 2016 at 3:52 am
Run
RESTORE DATABASE <database name> WITH RECOVERY
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 10, 2016 at 6:21 am
Viewing 15 posts - 3,076 through 3,090 (of 49,552 total)