Viewing 15 posts - 181 through 195 (of 1,048 total)
AS Koen said Please provide the actual execution plan then only we can provide you some suggestion...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 11:25 pm
Amit Raut (9/11/2013)
SELECT * FROM Table AINNER JOIN Table B
WHERE LEFT(A.UserName, 7) = B.ID -- RELEVANT FIELD FROM TABLE B
Its not a good practice to use functions like LEFT, RIGHT...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 11:18 pm
good one Mark 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 7:00 am
excelent articel..
thanks Grant 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 6:49 am
T-sql is the language which is used to write scripts.
SQL server is the engine
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 6:28 am
Please provide the tables structure and desired output.....
you can check the link in my signature about posting the question
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 6:26 am
Your requirement is not clear to me...
On what basis you are doing rhis thing-
for Grp 20, dated 05-11-2012, it needs to be compared to the max date for Grp 10...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 6:13 am
It will be good if you use BETWEEN to specify date ranges... I have made some changes in your SP and placed BETWEEN in where condition..
Please run and let us...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 5:33 am
adb2303 (9/9/2013)
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[myproc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[myproc]
GO
+1 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 5:22 am
SQLTestUser (9/9/2013)
IF EXISTS(
select 1 from Xlog where LogDATE >= cast(getDate() as date) -- should this be datetime if i have Sql server...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 5:20 am
Ryan1 (9/10/2013)
It makes a lot more sense when I see it written out in English.
I still don't get pivot views entirely. I can write out the...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 5:15 am
Please provide some more information.....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 11, 2013 at 5:12 am
Danny Ocean (9/10/2013)
handkot (9/10/2013)
I got an error: "String or binary data would be truncated. The statement has been terminated."(0 row(s) affected);-)
Just because of "Steppenwolf" having length 11. So insert...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 10, 2013 at 11:17 pm
what if the value if out of range of INT?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 4, 2013 at 6:15 am
Still only 71% got the right answer :w00t::w00t:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 2, 2013 at 10:59 pm
Viewing 15 posts - 181 through 195 (of 1,048 total)