Viewing 15 posts - 29,671 through 29,685 (of 49,552 total)
MibD (10/28/2010)
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
October 28, 2010 at 4:10 pm
Pthprod_log is the physical name of the file (E:\Databases\MSSQL\Data\Pthprod\Pthprod_log.ldf). You need either the logical name or the fileid.
Run this in the DB to get the logical name
SELECT df.name FROM sys.database_files...
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
October 28, 2010 at 4:08 pm
MibD (10/28/2010)
5. Changed the recovery model of PDB1 to simple and then shrinked the log file and the change the recorvey model back to FULL.
This broke the log chain. After...
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
October 28, 2010 at 4:04 pm
Not surprising.
With the where clause removed, the subquery will have more rows in it. Since it's a not in, more rows in the subquery can mean less rows in 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
October 28, 2010 at 3:38 pm
Craig Farrell (10/28/2010)
I believe the Picard Facepalm will be 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
October 28, 2010 at 2:55 pm
Grant Fritchey (10/28/2010)
Yeah, I stumble over the word "statistics" badly enough without having a mouth full of sugar.
At least you didn't take on an hour and a half presentation solely...
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
October 28, 2010 at 2:42 pm
Brandie Tarvin (10/28/2010)
What is DNRTV?
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
October 28, 2010 at 11:08 am
No.
The log is needed. It's not an optional portion of the database, it's necessary for the restored database to be transactionally and structurally consistent.
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
October 28, 2010 at 10:43 am
Brandie Tarvin (10/28/2010)
GilaMonster (10/28/2010)
Woot. Just got a mail fom my ISP. Bandwidth cap permanently increased by 1 GB, no additional charge. Excellent!AWESOME! Time to start watching some shows! @=)
I was...
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
October 28, 2010 at 10:32 am
Woot. Just got a mail fom my ISP. Bandwidth cap permanently increased by 1 GB, no additional charge. Excellent!
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
October 28, 2010 at 9:16 am
rootfixxxer (10/28/2010)
Yes there isn't any rule that tells that, but it should be... 🙂
Should it? Always? In every case?
Why?
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
October 28, 2010 at 9:14 am
rootfixxxer (10/28/2010)
DataWarehouses is obvious that must be denormalized. 😉
Really?
They often are, but there's no such rule.
Normalise fully. 4th normal form is probably a safe place to stop. Denormalise as necessary...
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
October 28, 2010 at 8:51 am
Rooms don't have start and end times (unless they only physically exist for certain times and vanish at others)
Schedules have start and end times. Booking slots have start and end...
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
October 28, 2010 at 8:49 am
Bhuvnesh (10/28/2010)
GilaMonster (10/27/2010)
Point is that the cluster is the largest index on the table (because it includes all columns).
Always ? What if i include only one column like empid...
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
October 28, 2010 at 8:25 am
Jeff Moden (10/28/2010)
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
October 28, 2010 at 3:19 am
Viewing 15 posts - 29,671 through 29,685 (of 49,552 total)