Viewing 15 posts - 1,261 through 1,275 (of 7,499 total)
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
- If the time interval is near constant, just start a sqlprofiler trace to capture all the needed and analyse it afterward.
- how are the backups being created at your...
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 16, 2013 at 12:48 pm
Isn't creation date and time information of the bak-file enough ?
To assemble a recovery requence, IMHO it is best to just pull all the needed data out of the msdb...
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 11, 2013 at 6:59 am
Viewing 15 posts - 1,261 through 1,275 (of 7,499 total)