Viewing 15 posts - 1,306 through 1,320 (of 2,458 total)
thenewbee (7/23/2015)
I wanted some experts commenting how to analyze a very...
July 23, 2015 at 10:47 am
Yeah, that won't work...
This is something you can accomplish using Dynamic SQL.
July 22, 2015 at 9:08 pm
For the life of me I can't think of a scenario why you would not want just a clustered unique index and drop index #2, anyone think of any scenario...
July 22, 2015 at 9:06 pm
I bet if you post the plan here that we can take a look at it and get an idea of what is killing your performance.
July 22, 2015 at 8:53 pm
Alvin Ramard (7/22/2015)
I vote for either temp table or table variable.
Yep.
July 22, 2015 at 5:25 pm
Out of curiosity, has SS array support improved in any way since 2008?
Yep, in 2012 they included CHOOSE.
I never see it used though....
Hmmmm, now I'm curious to how it...
July 22, 2015 at 3:53 pm
mak101 (7/2/2015)
How aboutRIGHT(REPLICATE('0',@size) + CAST(@value as varchar(max)),@size)
I was thinking the same thing (maybe not varchar(max) though ;-))
July 21, 2015 at 9:09 pm
Some DDL for the tables and underlying objects involved would be helpful. Note the link in my subject line.
Also, could you include the query plan that this query generates?...
July 21, 2015 at 8:53 pm
There's nothing attached. Keeping in mind I don't know how values are being assigned to what your stored procs are ingesting you could do something like this:
-- sample table using...
July 21, 2015 at 5:42 pm
You are on the right track. SSDT is the new BIDS. Notepad++ is still essential ;-).
My personal opinion is to learn/freshen up on XML; knowing XML has been extremely...
July 21, 2015 at 5:31 pm
Unless I'm missing something there's no reason to believe that that the two queries that you posted should return the same number of records.
I wanted to know if maybe we...
July 21, 2015 at 5:18 pm
SQL Guy 1 (7/21/2015)
July 21, 2015 at 12:48 pm
60% may not be big deal. You can keep an eye on it using DBCC SQLPERF(LOGSPACE).
If you consistently see that the tempdb log is filling you will want to...
July 21, 2015 at 11:41 am
You may want to consider adding a Subject field and an EmailChain ID field. Most applications that provide this type of functionality include a subject line. An EmailChain ID would...
July 21, 2015 at 10:38 am
mailtoashokberwal (7/20/2015)
I have a tableA in some DB on transaction server (Enterprise Edition), this table is being...
July 21, 2015 at 10:27 am
Viewing 15 posts - 1,306 through 1,320 (of 2,458 total)