Viewing 15 posts - 406 through 420 (of 3,232 total)
dbowlin (7/9/2010)
Steve Jones - Editor (7/9/2010)
dbowlin (7/9/2010)
I am not sure whether to...
July 9, 2010 at 11:13 am
Is there an update on your progress that you can give us?
July 9, 2010 at 9:13 am
CirquedeSQLeil (7/7/2010)
crookj (7/7/2010)
Ray K (7/7/2010)
Vacation (which ended yesterday -- what'd I miss?)Vacation - wish I was starting one 🙁
Joe
Just ended one and really need another.:-D
DITTO....I've been back home less than...
July 7, 2010 at 9:10 pm
Using my example from before:
DECLARE @Vendors TABLE (xid varchar(2), name varchar(20), internal bit)
INSERT INTO @Vendors
SELECT 'V1', 'Corporate University', 1 UNION ALL
SELECT 'V2', 'Learning Provider', 0
DECLARE @Companies TABLE (xid...
July 2, 2010 at 9:14 am
I agree with Paul, Steve and the rest. Partitioning is not the right tool for this job unless your users table has hundreds of millions of rows in it....
June 30, 2010 at 1:39 pm
DECLARE @Orders TABLE (OrderID int, ClientID int)
INSERT INTO @Orders
SELECT 1, 234 UNION ALL
SELECT 2, 234 UNION ALL
SELECT 3, 234 UNION ALL
SELECT 4, 200
DECLARE @Items TABLE (ItemID int, OrderID int)
INSERT INTO...
June 30, 2010 at 1:21 pm
I would recommend identifying the cause of the deadlocks and resolving it. There is most likely something inside the application code that is causing the deadlocks.
There is...
June 30, 2010 at 12:56 pm
In the meantime, consider this example:
DECLARE @Vendors TABLE (xid varchar(2), name varchar(20), internal bit)
INSERT INTO @Vendors
SELECT 'V1', 'Corporate University', 1 UNION ALL
SELECT 'V2', 'Learning Provider', 0
DECLARE @Companies TABLE (xid...
June 30, 2010 at 12:51 pm
Can you provide us with the DDL for the tables involved along with some sample data? See the link in my signature line for posting sample data.
June 30, 2010 at 12:34 pm
dg227 (6/30/2010)
June 30, 2010 at 10:27 am
dg227 is exactly correct in that you'll want to use variables to dynamically configure a task.
With that said, you still need to get the syntax down for your decrypt command....
June 30, 2010 at 10:16 am
Viewing 15 posts - 406 through 420 (of 3,232 total)