Viewing 15 posts - 2,086 through 2,100 (of 7,506 total)
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
just my 2ct.
Since you aim for minimal prod sys interference .... let's keep it simple.
How about lightweight tracing just for the the sp_prepare and sp_execute statements (of course capture...
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 8:42 am
As you have experienced, control server results in the same permission set as sysadmin.
A very good SSC ref pointing to this issue: http://www.sqlservercentral.com/blogs/brian_kelley/archive/2010/09/02/for-sql-server-2005-2008-consider-securityadmin-sysadmin.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
April 27, 2011 at 6:13 am
forsqlserver (4/27/2011)
Only sa has sysadmin.
Before 11 months I have add one windows domain user 'sqladmin' as login and 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
April 27, 2011 at 3:56 am
can you reveal the version info of your sqlserver instances that participate in this dbmirroring setup ?
@@version
or
Select Serverproperty( 'Edition' ) as Edition
, Serverproperty( 'ProductVersion' )...
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 27, 2011 at 12:21 am
That problem can be solved using a service broker solution ( event AUDIT_ADD_DB_USER_EVENT to be investigated ).
or maybe even using extended events. ( could be in the audit events. 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
April 26, 2011 at 12:36 am
Please elaborate on your findings, situation and results or side effects.
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 25, 2011 at 2:23 pm
Now you have it: Gail answering an question referencing her article.:hehe:
And she did answer it very good (as is her article).
Nothing to add.
My guideline for clix:
- pick one
- keep 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
April 25, 2011 at 2:00 pm
you have been bit by the "select * " monster !!!!!!
Specify the columns you want to use and you'll be ok.
Try to avoid the cursor in the first place.
did you...
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 25, 2011 at 1:25 pm
Viewing 15 posts - 2,086 through 2,100 (of 7,506 total)