Viewing 15 posts - 1,261 through 1,275 (of 7,501 total)
there is no catch block in your trigger. Is that how you intend it ? If so, don't use the try.
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
January 27, 2013 at 1:35 pm
just my 2ct, to add to previous responders replies:
In your sproc, chances are filter arguments aren't sniffed to your advantage at query plan generation time.
Reason for that is you are...
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
January 27, 2013 at 1:29 pm
check your sqlserver errorlog file to see what it is reporting about that database.
Keep in mind, you may have to process more than one errorlog file to get to the...
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
January 27, 2013 at 1:22 pm
3ms is the tollerance for a datetime data type.
why are you using implict transactions.
as in most cases, taking control yourself, using explicit transactions ( begin tran .... commit/rollback )...
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
January 25, 2013 at 12:41 pm
build up a solid view !
It's the combination that counts ... if it fits your needs and goals !
http://technet.microsoft.com/en-us/library/hh393576.aspx
http://msdn.microsoft.com/en-us/library/jj215886.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
January 23, 2013 at 5:08 am
Gianluca Sartori (1/23/2013)
Also, lots of useful code in there.
Thanks for sharing.
ALZDBA (1/23/2013)
In my test, [vs].[logical_volume_name] is blanc !
Win2008R2 / SQL2012DE (64-bit) SP1 (11.0.3000.0) with fixed...
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
January 23, 2013 at 2:30 am
Nice article, Erin.
In my test, [vs].[logical_volume_name] is blanc !
Win2008R2 / SQL2012DE (64-bit) SP1 (11.0.3000.0) with fixed drives.
So I suggest altering the last query to :
SELECT DISTINCT
...
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
January 23, 2013 at 1:16 am
This may be one of the cases where BOL is just wrong. :angry:
This does the trick you aim for:
Create default [MinusOne] as (-1);
go
/* Syntax error near Default --> CREATE TYPE...
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
January 21, 2013 at 2:00 am
as you will know Tempdb is a special db, available and used by everyone in the instance.
General usage of tempdb: http://msdn.microsoft.com/en-us/library/ms190768.aspx
Great post by Gail Shaw which highlights indexing and how...
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
January 21, 2013 at 1:50 am
if you copy/pated the statement in your previous reply ...
you typed dfault in stead of dEfault.
Chances are you overlooked the typing error.
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
January 21, 2013 at 1:35 am
it will write tempdb stuff to disk all right, it's just not at checkpoint time, like with regular db.
Why: tempdb is re-created every time SQLServer is started, so there is...
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
January 20, 2013 at 6:28 am
did you check with books online ?
Create type:
http://msdn.microsoft.com/en-us/library/ms175007(v=sql.105).aspx
My advice: Avoid like hell because they cannot be altered when they are in use. It's not all gold that shines
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
January 20, 2013 at 6:25 am
IMO it should return no row at all because of the where clause condition 1 = 0
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
January 18, 2013 at 3:21 am
With such findings, it is best to always mention the actual engine version on which you performed the test.
Select Serverproperty('ProductVersion') as ProductVersion
, Serverproperty('ProductLevel')...
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
January 18, 2013 at 3:07 am
Here's a good article to help you to get to your answer: SAN Replication vs. Clustering vs. Mirroring Which should be used when? by Denny Cherry.
It also contains an interesting...
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
January 18, 2013 at 3:00 am
Viewing 15 posts - 1,261 through 1,275 (of 7,501 total)