Viewing 15 posts - 2,071 through 2,085 (of 7,499 total)
Jeff Moden (5/3/2011)
ALZDBA (5/3/2011)
For sure it would have...
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
May 3, 2011 at 7:53 am
It's a pity some obscure character caught the attention of CNN, Bloomberg, Al Jazera, ... the day your great article got published.
For sure it would have been a headliner...
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
May 3, 2011 at 12:40 am
IMO this thread http://www.sqlservercentral.com/Forums/Topic1044430-391-1.aspx is a very good ref on DISK/SAN troubleshooting.
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
May 1, 2011 at 10:57 am
did you check these resources :
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
April 30, 2011 at 5:06 am
are you running the same edition ( standard + standard / ent + ent )
Can you find any in info in the errorlog files of both instances ?
How about capturing...
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
April 29, 2011 at 10:24 am
Aaarch i overlooked the fact this thread is in the ssis forum, hence my nonsense answer to your Q.
Sorry for that.:blush:
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
April 29, 2011 at 10:17 am
Some state this setting is only for 64-bit.
http://msdn2.microsoft.com/en-us/library/aa366720.aspx
states "?WOW64 on Intel Itanium-based systems does not support 32-bit applications that use this feature. The applications should be recompiled as native 64-bit...
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
April 29, 2011 at 7:56 am
niteshrajgopal (4/29/2011)
This looks very promising:-D I realised now that I need to return the table from a Function. I tried pasting the code into a Table Valued Function but...
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
April 29, 2011 at 3:56 am
Is this what you are looking for ?
Declare @Address table (FullAddress varchar(500) , Address1 varchar(500), Address2 varchar(500))
insert into @Address ( FullAddress ) values ( 'c/o Joel Robuck')
insert into @Address (...
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
April 29, 2011 at 2:43 am
apparently your mirroring partner hasn't been reachable.
Once both partners can see each other again, the mirroring will start to pull over the "missed" transactions and get itself into a "mirrored/synchronized/restoring"...
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
April 29, 2011 at 2:25 am
Maybe this can get you started
DECLARE @Loggings TABLE
(
[DATE] DATETIME NOT NULL
,[NAME] VARCHAR(100) NOT NULL
,[QTY] INT NOT NULL
...
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
April 29, 2011 at 2:08 am
Is deprecated ancient syntax ! ( get rid of it ! )
from BOL SQL2000:
Transact-SQL Joins
In earlier versions of Microsoft® SQL Server™ 2000, left and right outer join conditions were specified...
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
April 29, 2011 at 1:43 am
Jeff Moden (4/28/2011)
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
April 29, 2011 at 12:32 am
Ninja's_RGR'us (4/28/2011)
I'll put in an official request for my toy DB and I'll go from there.
We have a test environement but I can't overwrite it at will...
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
April 28, 2011 at 10:55 am
http://msdn.microsoft.com/en-us/library/ms174901%28v=sql.90%29.aspx
AFAIK: 3ways:
- the bol profiler way: http://msdn.microsoft.com/en-us/library/ms189604%28v=SQL.90%29.aspx
- the dta way: database tuning advisor ( been a while since I used that tool so I don't know how far that will...
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
April 28, 2011 at 9:12 am
Viewing 15 posts - 2,071 through 2,085 (of 7,499 total)