ChrisM@Work

Forum Replies Created

Viewing 15 posts - 3,991 through 4,005 (of 10,143 total)

RE: wildcards

Hany Helmy (9/11/2013)
Raghavendra Mudugal (9/11/2013)
Toreador
You clearly didn't analyse it very well then 😉
If I didn't then I would never had got the answer correct.. but I did, and this is...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 11, 2013 at 3:58 am

#1649177
RE: Format equivalant function in sql server 2008

Better still, using your example:
SELECT CONVERT(CHAR(2),DATEADD(m,-11,'2013-08-01'),10)
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 11, 2013 at 2:57 am

#1649149
RE: Format equivalant function in sql server 2008

JoyKing (9/11/2013)
Thanks for your quick reply, but we can use cast / convert only after applying datepart function.
It would be great, if you could able send test script.
Yes, but if...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 11, 2013 at 2:54 am

#1649146
RE: Format equivalant function in sql server 2008

DATEPART() or MONTH(). Both return INT so you may need to CAST.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 11, 2013 at 2:45 am

#1649143
RE: wildcards

Hany Helmy (9/11/2013)
I am really amazed of the 16 people (as of now) who got it right! :w00t:
Hope one of them will post a reply explaining how he got the...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 11, 2013 at 1:46 am

#1649126
RE: Recalculate Wages (Reposted for SQL 2008 with additional columns)

dwain.c (9/10/2013)
Perhaps it is overkill but is this a case where "fudge rounding" would help?
http://www.sqlservercentral.com/articles/Financial+Rounding/88067/
Dwain - possibly. The OP is using the rounded result of an earlier calculation to perform...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 11, 2013 at 1:03 am

#1649119
RE: Looking for ways to speed up complex query with frequent changes to underlying data

andybellenie (9/10/2013)
...almost all of the time is taken up waiting on the server for the first row...
Sorting is a blocking operator.
Can you post the actual execution plan for the...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 10, 2013 at 9:14 am

#1648939
RE: Deadlock involving Identity Column

The code too please James - or at least enough of it to be sure that it contains the insert (AMAC.dbo.ap_AuditLog_i line=44)
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 10, 2013 at 8:48 am

#1648916
RE: Query tuning performance

Dennis Post (9/10/2013)
Check out : http://ola.hallengren.com/
Learn the and understand the code.
When you do, you'll have no worries with these questions again.
Where in the linked site can I find out how...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 10, 2013 at 7:55 am

#1648893
RE: concatenate with leading zeros

paul.s.lach (9/10/2013)
Here is another variation on the math method that my testing says is a little faster:
DECLARE @Billion INT;
SET @Billion = 1000000000;
SET STATISTICS TIME ON;
SELECT @BitBucket =...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 10, 2013 at 6:53 am

#1648844
RE: Table name by a value

Run this to generate your scripts:
DECLARE @MySearchCriteria VARCHAR(500)
SET @MySearchCriteria = '''RO04381'',''RO04052'',''RO04210'''
SELECT 'SELECT ' + c.columnlist + ' FROM ' + t.name + ' WHERE ' + w.whereclause
FROM sys.tables t
CROSS...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 10, 2013 at 5:12 am

#1648803
RE: Insert and indexes

Post the query.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 10, 2013 at 4:33 am

#1648791
RE: Function Vs Stored Procedure

Are you asking this because you are curious, or because you want to use the output of a stored procedure as an input for a query? There are ways...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 10, 2013 at 4:32 am

#1648790
RE: Table name by a value

karunakar2351 (9/10/2013)
How to know a Table name by a value?
plz help me
Please explain in a little more detail what you mean, this is far too vague to answer.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 10, 2013 at 4:28 am

#1648788
RE: Help On Query

drop table #Sample
create table #Sample(Name Varchar(100),Role Varchar(10))
insert into #Sample values ('Vignesh' , 'Admin')
insert into #Sample values ('Vignesh' , 'User')
insert into #Sample values ('Bala' , 'Admin')
insert into #Sample values ('Bala' ,...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 10, 2013 at 2:28 am

#1648750

Viewing 15 posts - 3,991 through 4,005 (of 10,143 total)