Viewing 15 posts - 1,951 through 1,965 (of 3,232 total)
Thanks SQLGuru. Proving it was not really the problem. I had no problem comming up with enough data to point my finger at the SAN. I was...
December 11, 2007 at 12:47 pm
Dominic,
Your code works for me as well. I second looking at what Joel has suggested with your WHERE clause. Also, can you show us your call to...
December 11, 2007 at 11:20 am
sp_GetAppLock basically allows you to use SQL Servers locking space to serialize database object access. I think it has its uses but understanding SQL Server's default locking architecture when...
December 11, 2007 at 11:03 am
Colin,
You mentioned how telling the truth on SAN performance for DB servers tends to be going a bit against the grain and I'll agree. I've battled a bit...
December 11, 2007 at 9:02 am
Yep, pretty simple Peter. You'll need to prefix your columns with the appropriate alias as Sergiy is suggesting.
December 11, 2007 at 8:51 am
Wow, you guys were working late yesterday. Thanks for jumping in Sergiy. Steve (Stout), the example Sergiy gave you is exactly what I was describing. He was...
December 11, 2007 at 8:49 am
This is a very basic INSERT INTO...SELECT statement. You've already added in the column references into your INSERT INTO statement, you just need to add to the SELECT part...
December 10, 2007 at 4:03 pm
Set based means that you are working on 'sets' of data instead of rows. Anytime you can apply logic or business rules accross a set of common data, you'll...
December 10, 2007 at 3:30 pm
I think that you'll find the same problems in SQL Server 2005 as well. SQL Server is designed to work off sets of data. Row by row processing...
December 10, 2007 at 2:57 pm
In this case, not by using a CHECK Constraint (that I know of). You are limited to using a trigger to validate your data or add the checking logic...
December 7, 2007 at 3:18 pm
I would say that your answer is NO then. Check Constraints do not support the use of inline table valued functions.
December 7, 2007 at 1:58 pm
What did SQL Server tell you when you tried?
December 7, 2007 at 1:35 pm
Loner,
What is wrong with using a global variable to hold the output of T-SQL executed in the Execute SQL task? I do it all of the time. Isn't...
December 7, 2007 at 9:40 am
Post the plans and we can take a peek at them. Also, run each query in query analyzer using SET STATISTICS IO ON. Make sure to clean out...
December 4, 2007 at 11:00 am
Viewing 15 posts - 1,951 through 1,965 (of 3,232 total)