Viewing 15 posts - 1,096 through 1,110 (of 7,499 total)
Spot on for the weak spot detection !
Enjoy your holiday !
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
September 26, 2014 at 3:46 am
how about this:
/* still using the recursive CTE */
Create table MyTable ( Id int not null, Name varchar(128) not null, IdParent int NULL );
go
Create...
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
September 26, 2014 at 12:23 am
I guess your interesting read would be Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets[/url] and the sequels 😉
just solving your simple example using a cte can...
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
September 25, 2014 at 6:33 am
please refer to http://stackoverflow.com/questions/7843733/confused-about-updlock-holdlock
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
September 25, 2014 at 6:04 am
apparently just being member of 'public' on a database is enough to be able to script the create database statement. :crazy:
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
September 23, 2014 at 2:57 am
is the user member of any powerful instance level security group(s) or has the account been granted things 'on any database' ?
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
September 23, 2014 at 2:21 am
someone must have granted 'view definition TO ...' ;
e.g. to public ( not my favorite ! )
try:
deny view definition TO [ThatSpecificUser]
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
September 23, 2014 at 1:02 am
IMO that must be something that comes from either:
- someone executing DDL for implementation of stuff
or
- a dynamic sql statement someone is executing.
SQLserver will not let you implement DDL...
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
September 23, 2014 at 12:44 am
HowardW (9/10/2014)
You might...
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
September 11, 2014 at 12:09 am
I know you the values of query_hash and query_plan_hash are different and the columns serve different purposes.
My points are:
- why is query_hash of the sqlplan not equal with the query_hash...
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
September 9, 2014 at 7:13 am
start reading here : Database Mirroring (SQL Server 2012)
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
September 9, 2014 at 2:07 am
itmanagers (8/27/2014)
Hope you are doing fine.
I'm new using SQL backup jobs with multiple full, diff and log backups.
I have the following scenario
full- every day at 8:00pm
diff- every 4 hours
log- every...
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
August 28, 2014 at 12:49 am
Koen Verbeeck (8/4/2014)
ALZDBA (8/4/2014)
Koen Verbeeck (8/4/2014)
I have a rather large DWH query. For testing purposes I singled out one single ID.
But sometimes the query returned 1 row, sometimes...
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
August 4, 2014 at 7:55 am
Koen Verbeeck (8/4/2014)
I have a rather large DWH query. For testing purposes I singled out one single ID.
But sometimes the query returned 1 row, sometimes 2, while it...
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
August 4, 2014 at 7:31 am
vinodmmec916 (8/4/2014)
I want to know whether we can create an automated html format mail for new users and it has to be immediate as soon as a new user...
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
August 4, 2014 at 1:04 am
Viewing 15 posts - 1,096 through 1,110 (of 7,499 total)