Viewing 15 posts - 4,231 through 4,245 (of 7,502 total)
Since partitioning is an advanced topic, it is highly recommendable to read BOL and to read the white paper on partitioning.
(make sure you have the latest version of BOL !)
-SQL2005...
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
December 22, 2008 at 12:21 am
can you also insert/update/delete on the pricipal instance ?
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
December 22, 2008 at 12:16 am
SQL2005 : http://www.microsoft.com/Sqlserver/2005/en/us/Compare-Features.aspx
SQL2008: http://www.microsoft.com/sqlserver/2008/en/us/editions.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
December 22, 2008 at 12:08 am
Maybe.
However, when using windows groups to grant security, we don't have control about the actual account being used.
So finding the "exceptions" would be a trial and error thing :crazy:
and would...
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
December 20, 2008 at 3:05 am
Well, this is sql2005
xp_cmdshell is off by default.
You would be better off just exporting the result using SQLCMD or DBMail if you want to email it.
Check out BOL
e.g
sqlcmd -s yourserver\instance...
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
December 20, 2008 at 3:02 am
Grant Fritchey (12/19/2008)
DO NOT, I repeat, DO NOT, GO PUTTIN' FRUIT INTO MY GOL DURNED BEER.
Belgians... They get a couple of things right (double, triple, & saison (very right))...
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
December 19, 2008 at 7:59 am
Finaly we are getting to the essence of being :w00t::w00t:
beer and food 🙂
I prefere a very good Geuze Lambic (the bottle with natural cork please) :smooooth:
I'm not that picky...
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
December 19, 2008 at 7:36 am
The strange thing is that I get a @@trancount = 3 at execution time ...
So that would get me to writing another
while @@trancount > 0
Begin
...
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
December 19, 2008 at 7:19 am
same player shoot again ... hit ball when lights are on ...
Select *
, Sum_Y - Sum_N as Subtracted
from (
select sum(CASE table1.column2 WHEN 'N' THEN table1.column1
ELSE 0
END ) 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
December 19, 2008 at 4:54 am
I'm glad one of our biztalk devs is very cooperative today 😉
Scenarion 1 : add begin tran ... commit tran
Just encapsulating the trigger with its own Begin tran ... commit...
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
December 19, 2008 at 3:08 am
Jeff Moden (12/18/2008)
... we now have two national languages just due to immigration.
Due to WWII we have 3 official languages 😉
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
December 18, 2008 at 7:23 am
tempdb is the system working area of sqlserver.
Probably it needed to extend one of its files and hasn't been able to do that within the timeout limit.
Check your tempdb files...
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
December 18, 2008 at 3:15 am
Without any select query example , this is the best I can come up with 😉
To get you on track ...
Select a.col1 as mygroupcolumn
, sum(b.colx) as sum_colx
, sum(c.col1a) as sum_col1a
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
December 18, 2008 at 3:12 am
YSLGuru (12/17/2008)
HUH?
What makes you think I want this to rteurn more then 8000 bytes? The problem is that Replace() is retruning TOO MUCH text by adding a...
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
December 18, 2008 at 12:07 am
I didn't forget this thread !
I'm not at the office today.
I'll get back to this tomorrow.
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
December 17, 2008 at 5:21 am
Viewing 15 posts - 4,231 through 4,245 (of 7,502 total)