Viewing 15 posts - 4,456 through 4,470 (of 10,144 total)
paul.knibbs (6/27/2013)
Is ISNULL such an expensive operation, then? (Genuinely curious, never actually sat down and analysed it)...
It's not expensive, but it's not free either. Have a look at the actual...
June 27, 2013 at 2:31 am
Jeff Moden (6/24/2013)
ChrisM@Work (6/20/2013)
Venkata-433090 (6/19/2013)
Thanks for your response. Its kind of when the client retrieves the data.again, the 32 character count should start from where the pipe was placed.
Shouldn't...
June 27, 2013 at 2:22 am
Revenant (6/26/2013)
opc.three (6/26/2013)
The Dixie Flatline (6/26/2013)
Cliff Jones (6/26/2013)
JAZZ Master (6/26/2013)
crookj (6/26/2013)
WOTD - atrophya trophy
Stanley Cup
Athletic Supporter
Cheerleader
pom poms
pomfret
June 27, 2013 at 1:14 am
Luis Cazares (6/25/2013)
Sean Pearce (6/25/2013)
michal.lisinski (6/25/2013)
You have the right to disagree with my opinion, but there is no "right" answer here. For data that is not meant to persist...
June 25, 2013 at 8:39 am
-- no cursors are required here:
-- Construct a table from the list of invoice numbers
IF object_id('TempDB..#InvoiceList') IS NOT NULL
DROP TABLE #InvoiceList
SELECT inv_num
INTO #InvoiceList
FROM (
SELECT inv_num =
dbo.ExpandKy(10, @Inv1) UNION ALL
dbo.ExpandKy(10,...
June 25, 2013 at 8:29 am
Dird (6/25/2013)
Wouldn't you use IS NOT NULL and > 0?
No, you would use <> 0
SELECT d.Amt
FROM (SELECT Amt = 1 UNION ALL SELECT 22 UNION ALL SELECT 0 UNION ALL...
June 25, 2013 at 5:18 am
Minnu (6/25/2013)
Hi,there are no locks on table, selecting data by specefying NOLOCK only, still gettting the same problem.
Please suggest...!
Please answer!
ChrisM@Work (6/25/2013)
Do you...
June 25, 2013 at 4:10 am
Abu Dina (6/24/2013)
ChrisM@Work (6/24/2013)
Abu Dina (6/24/2013)
DECLARE @pairs TABLE (dropped_id INT, retained_id INT)
INSERT INTO @pairs
SELECT 16492, 23011 UNION ALL
SELECT 23011,24014 UNION ALL
SELECT 23011,24951 UNION...
June 25, 2013 at 2:09 am
Today's ssc headlines include an article by Hugo Cornelis on partitioning logging tables to enable fast deletes. It's a step by step how-to guide and covers partitioning an existing table....
June 25, 2013 at 2:07 am
Post the ddl (CREATE TABLE ...) including any indexes.
Do you get the full set of rows if you restrict to one column in the SELECT? Does NOLOCK make any difference?
SELECT...
June 25, 2013 at 1:34 am
Lucky9 (6/12/2013)
...
so with the above problem what is the best...
June 25, 2013 at 1:29 am
Avik Roy (6/24/2013)
Hi All,I need your urgent help regarding this procedure performance tuning so that the execution time become very less.
Below is the procedure :
...
Your stored procedure looks like the...
June 25, 2013 at 1:24 am
spaghettidba (6/24/2013)
Paul, your answers could be collected in a book and it would be an absolute best-seller!Awesome, as usual.
Absolutely. Paul, you don't often post on ssc these days, but when...
June 25, 2013 at 1:02 am
Abu Dina (6/24/2013)
DECLARE @pairs TABLE (dropped_id INT, retained_id INT)
INSERT INTO @pairs
SELECT 16492, 23011 UNION ALL
SELECT 23011,24014 UNION ALL
SELECT 23011,24951 UNION ALL
SELECT 16492,24951 UNION...
June 24, 2013 at 8:59 am
Something like the algorithms for obtaining datetime from sysjobhistory run date and run time:
SELECT
jh.run_date,
jh.run_time,
RunDateTime = x.RunDate + x.RunTime
FROM msdb.dbo.sysjobhistory jh
CROSS APPLY (
SELECT
RunDate = CAST(STR(jh.run_date, 8,...
June 24, 2013 at 8:43 am
Viewing 15 posts - 4,456 through 4,470 (of 10,144 total)