Viewing 15 posts - 376 through 390 (of 492 total)
What I want to know is: Why do you need to "clean TempDB?" TempDB is just that, temporary! Objects created there disappear when their creating SPID disconnects. If this isn't...
August 3, 2010 at 3:38 pm
An odd bit of behaviour I've noted with dropping databases is that, if the database is OffLine when you drop it, the physical files are not deleted.
Does anyone know why...
August 2, 2010 at 5:47 pm
Besides the fact that the code is really very inefficiently (dare I say badly) written, the first obvious thing that could be causing the deadlock is the fact that there...
August 2, 2010 at 5:12 pm
Help, doesn't ANYONE have something to say about my question?
I need to solve this.
Leo
August 2, 2010 at 4:43 pm
Besides the deadloc trace image, you also need to supply the rest of the deadlock information. One way of doing this is by enabeling the Trace Flag 1204. This will...
July 21, 2010 at 9:39 pm
Are the CPUs Hyper Threaded?
First off I'd almost never run SQL Server 2005 on a single processor core, which is what I assume you are doing. Your per-processor licence (which...
July 21, 2010 at 8:31 pm
Yes, I can see ALL my posts here, but I don't need that, besides I have to wade through them to find the chains I started, and I have to...
July 21, 2010 at 7:59 pm
You don't say what edition of SQL Server 2005 you are using, Standards or Enterprise.
Note that if you are using Standard Edition Lock Pages In Memory was only available from...
July 15, 2010 at 6:52 pm
You need to understand what a snapshot does to know if it will do waht you want.
Taking a snapshot actually creates an empty database, with a view over the real...
July 15, 2010 at 3:27 pm
dave.hobbs (7/13/2010)
I hadn't considered A/A clusters before as we have always wanted some level of passive redundancy, but now I'm not sure that it is worth...
July 14, 2010 at 3:20 pm
Leo.Miller (7/13/2010)
2) How does the number of rows being updated change if you ignore the WHERE clause? This clause is of no value
Sorry, ignore this point. I wasn't thinking...
July 13, 2010 at 4:32 pm
Anye Mercy (7/13/2010)
update top(BatchSize) MainTable set IntFK7=@someint, UserID=@myid, ChangeDate=@date from maintable M inner join temptable T on M.PkeyField=T.PkeyFieldwhere M.IntFK7 <> @someint
Two things come to mind:
1) You are changing the...
July 13, 2010 at 4:31 pm
Not quite a question for the SQL Admins, as it really applies to an application, and your application vendor should be able to answer this. It just so happens I've...
July 13, 2010 at 2:01 pm
mohammed moinudheen (7/13/2010)
July 13, 2010 at 1:51 pm
That is true. Unfortunately there will still be a UDP 1434 still read with every SQL install. With the named instances, you achieve Obfuscation of your instances but...
July 12, 2010 at 8:06 pm
Viewing 15 posts - 376 through 390 (of 492 total)