Viewing 15 posts - 39,541 through 39,555 (of 49,552 total)
Jesse McLain (4/23/2009)
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
April 23, 2009 at 11:43 am
Default autogrow on data and log
No indexes or constraints on Products. The cluster on Main is going to fragment quite badly, depending how often the inserts/updates are.
Product price is inconsistent...
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
April 23, 2009 at 11:15 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
April 23, 2009 at 11:09 am
To restore to a point in time with log backups you need a full backup and all of the log backups (unbroken chain) from the full backup up until 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
April 23, 2009 at 10:40 am
Alvin Ramard (4/23/2009)
hmmmm...Where would one look for examples of bad SQL? (I'm ducking to avoid flying pork chops) 😀
My presentation from last year had some made up bad...
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
April 23, 2009 at 9:49 am
dev_programmer (4/23/2009)
Please give me some practise papers that would allow me to judge myself with various sections of sql server 2005.
As i said, the only 'free' practice papers that you're...
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
April 23, 2009 at 9:02 am
http://sqlinthewild.co.za/index.php/2009/04/11/pass-summit-submissions/
You need the following:
- Your biography
- A title (eye catching or at least intriguing)
- Short abstract
- 3 goals of the presentation
- Requirements - what people need to know to follow
-...
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
April 23, 2009 at 8:17 am
dev_programmer (4/22/2009)
where can get practice test papers for free as i cant afford the amount asked.
The vast majority of 'free' practice test papers that you will find are 'brain dumps',...
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
April 23, 2009 at 8:09 am
Hmm, looks like you have one of the parts of a striped backup. It commonly happens when a backup is taken through management studio and there are two (or 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
April 23, 2009 at 7:49 am
Bob Hovious (4/23/2009)
Thanks everyone, I truly hope I can be in the audience for some of your presentations.
You didn't submit an abstract?
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
April 23, 2009 at 7:38 am
If you've already restored the full backup, you can't go back as the restore would have overwritten the existing database. You can just run the following to bring it out...
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
April 23, 2009 at 7:35 am
Change the primary key to clustered. Is there any good reason it was created as a nonclustered index in the first place?
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
April 23, 2009 at 7:31 am
mithun.gite (4/23/2009)
ok means the max row size is 8060 bytes and anything more than then resides off the page , right...
No.
The max row size is 8060 bytes and creating a...
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
April 23, 2009 at 4:05 am
Post the trigger code and the T-SQL 'shell' for 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
April 23, 2009 at 3:40 am
create table my table (str1 varchar(3000),
str2 varchar(3000)
str3 varchar(3000)
)
it created the table and i entered 3000 chars in all columns and it working fine.
Yup. Varchar are variable length character data. See...
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
April 23, 2009 at 3:36 am
Viewing 15 posts - 39,541 through 39,555 (of 49,552 total)