Viewing 15 posts - 21,886 through 21,900 (of 22,194 total)
OK. It only bothers me when I read a stinky article that I want to slam
No big deal. I was just curious really.
April 23, 2007 at 10:06 am
Don't put the cluster on the GUID.
Experimentation is the key. Just a swag, put the cluster on the date column and then, depending on the manner in which the...
April 23, 2007 at 7:47 am
Since you're doing deletes, you're probably going to get some blocking no matter what you do. First off, I'd look into eliminating the WHERE IN & WHERE NOT IN queries....
April 23, 2007 at 7:40 am
Check this knowledge base article on MSDN:
http://support.microsoft.com/kb/321185
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
April 20, 2007 at 10:48 am
Some indication of the code being called would help.
April 19, 2007 at 1:21 pm
Hard topic to quantify. The one point I'd add is that mediocre or not, you basically have people falling roughly into two groups. Those that have a year or two...
April 19, 2007 at 5:33 am
Yow! What a question. Well, everyone has their own opinions. What's more, every situation is a little different. I'm working on an article right now for Simple-Talk on just this...
April 19, 2007 at 5:22 am
I'm sorry, I'm not sure. I just did the same thing you described and it worked fine.
April 18, 2007 at 11:30 am
Then you sir, are a gentleman and a scholar. I'm neither. Pass the hammer please.
April 18, 2007 at 7:46 am
sp_who2 is a simple way to see which processes are running. It shows the SPID. You can use that to kill a process.
I'm not sure if this is the answer...
April 18, 2007 at 7:04 am
Yeah, you'll need to change the app. The methods for accessing system metadata within SQL 2005 are different than they were in 2000. The views that look like the old...
April 18, 2007 at 7:01 am
That completely depends on your environment. For example, we have a server environment where some 3rd party apps are running that need 'sa' log-in in order to operate (can I...
April 18, 2007 at 6:57 am
Nope, sorry. Common Table Expressions are new in 2005.
April 18, 2007 at 5:12 am
I read this yesterday and wasn't sure what you're looking for. Would a common table expression work? This is derived from BOL:
WITH TableX AS
(SELECT e.ManagerId, e.EmployeeId, 0 AS Level
...
April 17, 2007 at 11:58 am
If you run a query against the sys.sysobjects system view in the master db, do you still see it?
SELECT * FROM sys.sysobjects
WHERE NAME = 'sp_executesql'
If so, note the type. It's...
April 17, 2007 at 11:50 am
Viewing 15 posts - 21,886 through 21,900 (of 22,194 total)