Forum Replies Created
Viewing 15 posts - 1,681 through 1,695 (of 7,499 total)
-
RE: Add one min when time same
edited ... removed the quoted text :blush:
Can you use Row_Number() over ( partition by yourdatecol order by yourdatecol ) as RwNumber
and add that ( - 1)
e.g.
update x
set ...
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
-
RE: SQL - Query takes long time to execute...
How about :
;
With cteDocCounter
as (
...
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
-
RE: Query Help
Check out Jeff Moden's wonderful "DelimitedSplit8K" http://www.sqlservercentral.com/Forums/Topic943562-338-1.aspx#bm944589
It will get you started on resolving your quest 😎
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
-
RE: Joining 2 databases without hardcoding database name
I would create a synonym in the database, referring to the table in the other database.
Check "CREATE SYNONYM" in books online
ps I prefer still leaving a trace in the naming...
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
-
RE: Are the posted questions getting worse?
SQLRNNR (9/15/2011)
Tom.Thomson (9/15/2011)
Steve Jones - SSC Editor (9/15/2011)
Please let's not have quotes of every post that counts down from 95, 94, 93.I'm going out of town for a few days....
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
-
RE: Are the posted questions getting worse?
SQLRNNR (9/15/2011)
WayneS (9/15/2011)
SQLRNNR (9/15/2011)
Just saying that we only need 98 more posts for 30,000how many?
Ummm - 96
Make up your mind. No guessing 😉
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
-
RE: Are the posted questions getting worse?
Jeff Moden (9/14/2011)
ALZDBA (9/14/2011)
jcrawf02 (9/14/2011)
Grant Fritchey (9/14/2011)
mtillman-921105 (9/14/2011)
Grant Fritchey (9/14/2011)
Changing the topic for a moment, I'd like to beg some ideas from the group, again.I'm tasked with writing another article....
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
-
RE: Are the posted questions getting worse?
jcrawf02 (9/14/2011)
Grant Fritchey (9/14/2011)
mtillman-921105 (9/14/2011)
Grant Fritchey (9/14/2011)
Changing the topic for a moment, I'd like to beg some ideas from the group, again.I'm tasked with writing another article. This one 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
-
RE: Are the posted questions getting worse?
Grant Fritchey (9/14/2011)
Changing the topic for a moment, I'd like to beg some ideas from the group, again.I'm tasked with writing another article. This one is all about the scary,...
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
-
RE: Mirroring mystery - can't quite figure it out
Perry Whittle (9/14/2011)
sqlbuddy123 (9/13/2011)
Right, Mirrored DB is not accessible at all times.Thank You,
Best Regards,
SQLBuddy
Unless you're using...
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
-
RE: Jeff Moden elected Exceptional DBA of 2011
This is a great recognition and thank you for all time, energy en knowledge Jeff developed and shares !
Congratulations, Jeff
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
-
RE: Are the posted questions getting worse?
We get to hear "Ho, ho, hoo" at SQLPASS 2011 !!!!
http://www.sqlservercentral.com/articles/Exceptional+DBA+Awards/75988/
Congratulations Jeff !!
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
-
RE: Are the posted questions getting worse?
Jan Van der Eecken (9/13/2011)
ALZDBA (9/13/2011)
SQLRNNR (9/13/2011)
Steve Jones - SSC Editor (9/13/2011)
New building looking good for the horses:
Now we know where Steve will be sleeping when in the dog house.
I...
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
-
RE: Store all in one database instead of one prodcution database and one historic database
just saying ..
Would your business clients appreciate the apps not working whilest some one consumes historic data and scans all your lovely large tables pushing regular oltp stuff out of...
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
-
RE: Are the posted questions getting worse?
SQLRNNR (9/13/2011)
Steve Jones - SSC Editor (9/13/2011)
New building looking good for the horses:
Now we know where Steve will be sleeping when in the dog house.
I think he's expecting to host...
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
Viewing 15 posts - 1,681 through 1,695 (of 7,499 total)