Viewing 15 posts - 1,231 through 1,245 (of 7,505 total)
could be kind of application logging that has been implemented and enabled.
Could it be an insert on a cursor-ed object (ado recordset insert) ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 25, 2013 at 6:53 am
unlike the old syntax ( not using the keyword JOIN ) the placement of the on-clause predicates don't play a role in determining the left part of your left join.
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 24, 2013 at 12:23 am
+5 stars ( and that's just because that is the maximum supported over here ) :hehe:
Well said, Jeff :w00t:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 24, 2013 at 12:16 am
the way you did it is grouping by minute ( not taking year/month/day/hour into account )
This is how I would do it.
SELECT
datepart(mi,[startDate]) as MI,
min(startDate) as startDate,
avg(duration) Duration
FROM ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 23, 2013 at 2:15 am
well, consider it as if you were to write the from part in a (long) single line
In English, we read it from left to right, correct ?
Hence a left...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 23, 2013 at 2:06 am
I'm glad SSC republished your fine article, Gianluca.
Nice work, great descussions.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 21, 2013 at 2:58 am
did you try :
, CASE WHEN ss.enabled IS NOT NULL THEN 'Schedule is enabled'
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 11, 2013 at 12:21 am
please check out the procedure described at msdn: How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005 : http://msdn.microsoft.com/en-us/library/ms143799%28v=sql.90%29.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 10, 2013 at 6:10 am
As documented in BOL: TRUNCATE TABLE (Transact-SQL)
Restrictions
You cannot use TRUNCATE TABLE on tables that:
Are referenced by a FOREIGN KEY constraint. (You can truncate a table that...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 6, 2013 at 11:58 pm
Tested it from home using SSMS2008R2 (sp2): Works like a charm 🙂
Now to get our company network admins to open the required port :crazy:
ref:Guidelines for Connecting to Windows...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 22, 2013 at 2:23 am
What data type did you define the column you are refering to ?
/* Example using DateTime data type */
Select DATEADD(HH, datediff(HH, 0, getdate()) - 1, 0) FromHH
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 17, 2013 at 1:39 am
why are you storing numeric values in a varchar column. As experienced, this will get you in troubles.
( in most cases because of formatting issues or just because someone put...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 15, 2013 at 11:51 pm
How about this list:
What's New (SQL Server 2008) http://msdn.microsoft.com/en-us/library/bb500435%28v=sql.100%29.aspx
What's New (SQL Server 2008 R2) http://msdn.microsoft.com/en-us/library/bb500435%28v=sql.105%29.aspx
What's New in SQL Server 2012 http://msdn.microsoft.com/en-us/library/bb500435.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 15, 2013 at 11:46 pm
I would examine the execution plan as a first step.
You can export it to a .sqlplan file if you want to, and add it as an attachment to your forum...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 15, 2013 at 11:42 pm
Lynn Pettis (4/9/2013)
Create an empty database and run the following:...
Tested your script at my slow box:
CPU(ms): 102009 Logical Reads: 10002259 Elapsed(ms): ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 9, 2013 at 11:50 pm
Viewing 15 posts - 1,231 through 1,245 (of 7,505 total)