Viewing 15 posts - 41,506 through 41,520 (of 49,552 total)
gavin.duncan (1/22/2009)
The table has a user-defined column called Sequence, its to be ordered by that. Im having a look at Row_Number as we speak.
SELECT * FROM (
SELECT *, ROW_NUMBER() OVER...
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
January 22, 2009 at 6:13 am
ifila (1/22/2009)
Dumb question, but why do you need seperate full and log backups ?
I'm not saying you need to separate them. I'm saying they're separate things.
Please read through this...
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
January 22, 2009 at 6:10 am
lucassouzace (1/22/2009)
ok, but this example, the query using union all more better union do you think ?
In your specific example, because there are no overlaps (rows in more than one...
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
January 22, 2009 at 5:42 am
ifila (1/22/2009)
I run a full database backup each day, and have about one weeks worth of daily backups.
Log backups? In full recovery, full backups alone are not sufficient.
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
January 22, 2009 at 5:40 am
gavin.duncan (1/22/2009)
OK, I'm trying to write query which will return the rows 2-10 from a table. Essentially the top ten, minus the top result.
Row_Number is what you're looking for. Rows...
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
January 22, 2009 at 5:39 am
serge.kovacs (1/22/2009)
while the DB itself is taking almost 2 GB now, and is still growing.
That's tiny. 🙂
Do you think it could help to increase the amount of RAM...
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
January 22, 2009 at 5:37 am
The best way to post the table definitions is as create statements, so that the people who are trying to help you can easily create those tables to test 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
January 22, 2009 at 4:08 am
Hadrian (1/22/2009)
check status in sysdatabases must be suspect for corrupted mdf files
Not necessarily. There are many forms of corruption that won't result in the DB been marked suspect. That's pretty...
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
January 22, 2009 at 4:01 am
vaibhavi5575 (1/22/2009)
My projects includes working on Java and Ruby on Rails and Ajax. I think Web Services is really cool.
You may get better advice on a forum that caters...
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
January 22, 2009 at 3:58 am
Run checkDB and see if it gives you any errors. There are a lot of possible errors that checkDB will give back, so I won't try and list them.
Is this...
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
January 22, 2009 at 3:57 am
I'm not sure I fully understand your requirements.
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
January 22, 2009 at 3:54 am
Rajesh kasturi (1/22/2009)
Thanks for your reply, While rebuilding the index log file will be used or data file will be used.
Both. The data file because that's where the new...
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
January 22, 2009 at 3:52 am
serge.kovacs (1/22/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
January 22, 2009 at 3:52 am
Suggest to the sharepoint admin that it would be better to take backups to the local disk and later move them to a network share?
If that's not an option, ensure...
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
January 22, 2009 at 12:37 am
ifila (1/21/2009)
Not looking for an argument, but why does MS offer a shrink capability if it is a bad idea ?
Because there are times when it's necessary. Note that...
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
January 22, 2009 at 12:36 am
Viewing 15 posts - 41,506 through 41,520 (of 49,552 total)