Viewing 15 posts - 16 through 30 (of 111 total)
with that amount of CPU/RAM your main contention will be I/O
Don't just grab from the top shelf if you don't require it, you will probably waste money.
Depending on your speed...
April 26, 2011 at 2:28 pm
ok, i got the first part, finding where it is
ex:
select B.* from table cross apply sys.fn_PhysLocCracker(%%physloc%%) B
edit:
Thanks, I am working with a copy of the production database...
April 12, 2011 at 12:47 pm
Thanks everyone, I think I got the point.
Now the only thing I'm still curious is to find the actual row location, and a way to migrate all of into into...
April 12, 2011 at 12:41 pm
SQLkiwi (3/18/2011)
dant12 (3/18/2011)
March 18, 2011 at 1:30 pm
SQLkiwi (3/17/2011)
dant12 (3/17/2011)
March 18, 2011 at 10:12 am
TT-131210 (3/17/2011)
Both examples work great but COALESCE() is simple.Thank you
coalesce will only work if you always only have 1 column filled, if col1 = 'a' and col2 = 'b' coalesce...
March 17, 2011 at 2:59 pm
you need UNPIVOT
DECLARE @a TABLE (COL1 VARCHAR, COL2 VARCHAR,COL3 VARCHAR)
INSERT INTO @a
SELECT 'A',NULL,NULL UNION ALL
SELECT NULL,'B',NULL UNION ALL
SELECT NULL,NULL,'C'
SELECT X
FROM
(
SELECT *
FROM @a
) A
UNPIVOT...
March 17, 2011 at 2:51 pm
GSquared (3/17/2011)
March 17, 2011 at 2:46 pm
If you are just syncing stuff and not actually using this common database it CAN be a good thing.
You probably want to set up replication on those objects so when...
March 17, 2011 at 2:39 pm
Agree with Chris, your best option is to always insert the excel sheet in a staging table and MERGE it with the actual table doing update when matched and inserting...
March 17, 2011 at 2:33 pm
you should be profiling the queries that are being run against the server together with perfmon, even if you don't think a period should be experiencing "heavy loads" some poor...
March 11, 2011 at 9:49 am
i often use something more simple
DECLARE @TARGET INT
WHILE 1=1
BEGIN
DECLARE KILLCONS CURSOR LOCAL FAST_FORWARD FOR
SELECT SPID FROM MASTER..SYSPROCESSES WHERE DBID = DB_ID('DB NAME') AND SPID >=50
OPEN KILLCONS
FETCH NEXT FROM KILLCONS INTO...
March 1, 2011 at 7:10 am
Just got error 0xC0047020(unable to process the data) on the ado.net source then a following 0xC02090F5(something with PrimeOutput method in the message) error
I have no idea what this means and...
February 25, 2011 at 2:40 pm
the way im doing it right now is a foreach loop only to loop through the 5 databases i need to query.
the query also returns parts of the destination folder,...
February 25, 2011 at 2:04 pm
Phil Parkin (2/24/2011)
My first idea would be to use an Execute SQL task to populate an...
February 24, 2011 at 12:29 pm
Viewing 15 posts - 16 through 30 (of 111 total)