Viewing 15 posts - 41,521 through 41,535 (of 49,571 total)
DBADave (1/22/2009)
Deadlocks can frequently occur on SQL Server 2005 as SQL Server 2005 place locks on the page level rather than row levelDo you agree with this statement?
No.
All versions...
January 22, 2009 at 6:52 am
In addition, an administrator could put a packet sniffer in place and read all of the network packets coming into the server. Unless you've got those encrypted, that'll reveal...
January 22, 2009 at 6:39 am
Great. Now give some though to good log management so that this won't happen in the future.
January 22, 2009 at 6:36 am
onlyvikas2004 (1/22/2009)
that means no way to restrict sysadmin at all? :crying:
No. That's the definition of sysadmin.
January 22, 2009 at 6:15 am
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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/
January 22, 2009 at 3:54 am
Viewing 15 posts - 41,521 through 41,535 (of 49,571 total)