Viewing 15 posts - 41,506 through 41,520 (of 49,562 total)
DBADave (1/22/2009)
Another statement they made in the doc is that we should identify the code causing the deadlocks and add indexes if necessary to resolve the problem.
Other problem...
January 22, 2009 at 7:59 am
Please post new questions in a new thread (in an appropriate forum) as people may miss it at the end of an existing thread, and SSIS people may well not...
January 22, 2009 at 7:58 am
So cast the uniqueidentifier to a varchar before concatenating.
Why do you have denormalised tables? What's the reason for putting lists into a single column instead of into a child table...
January 22, 2009 at 7:31 am
ashepard (1/22/2009)
Hi. Yes there is a temporary internal table for the resultant set rows that the cursor runs against I believe
That's cursors. Not general queries
For general queries,...
January 22, 2009 at 7:28 am
Nothing in the SQL error log at all?
January 22, 2009 at 7:12 am
Lowell (1/21/2009)
really, i think there are only like 6 questions that keep getting repeated over 90 percent of the posts, and the other 10% are the ones that we enjoy.
You...
January 22, 2009 at 7:00 am
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
Viewing 15 posts - 41,506 through 41,520 (of 49,562 total)