Viewing 15 posts - 2,056 through 2,070 (of 7,499 total)
another thing to keep in mind with any hints is :
As with data volume changes, you'll also have to check their working and the need for them every time...
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 10, 2011 at 12:32 am
just my 2ct to solve a design flaw...
- Since it can only hold one the the 4 key values, maybe actually design 4 columns with fk ref to their corresponding...
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 9, 2011 at 3:09 pm
Adam did a great series about using whoisactive .
If you find any problems contact him directly.
He'll appreciate your feedback and he reacts fairly quick.
I use the (also free) WhoIsActiveUI...
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 9, 2011 at 12:16 pm
what's the rowlength / setsize of the returned 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
May 9, 2011 at 10:44 am
checksum can produce duplicates !
So, even when using a checksum column to identify a row, best is to still add e.g. primary key columns to be sure you are modifying...
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 4, 2011 at 2:06 pm
SQLRNNR (5/4/2011)
ALZDBA (5/4/2011)
Failedconnectiontracker is using sqlserver event notifications to capture all login info.
We have a dba database on every sqlserver instance to host all sysadmin/dba systems...
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 4, 2011 at 2:03 pm
I'm glad you managed to use the failedconnectiontracker 😉
So it must be a local process, non sqlagent direct related.
( i mean a sqlagent job has recognisable text sqlagent in the...
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 4, 2011 at 2:01 pm
that may be normal, depending on the size of your table.
The clustered index actually holds the data rows at its leaf level (bottom level)
So, if you drop the clustered index,...
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 4, 2011 at 1:53 pm
Maybe this can help out.
Failedconnectiontracker is using sqlserver event notifications to capture all login info.
We have a dba database on every sqlserver instance to host all sysadmin/dba systems stuff.
In the...
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 4, 2011 at 10:28 am
Did you manage to resolve your question ?
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 4, 2011 at 8:08 am
- can you post @@version information of your sql2005 instance?
- did you perform post migration maintenance on the db ?
( DBCC CHECKDB (0) WITH ALL_ERRORMSGS, DATA_PURITY;
...
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 4, 2011 at 8:05 am
no !
e.g. db_datareader database group is allowed to read all data of all tables and views
do you have the needed authority to view that info ?
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 4, 2011 at 8:00 am
Ninja's_RGR'us (5/4/2011)
This is advanced stuff and you should not start that project under pressure. And...
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 4, 2011 at 7:50 am
bitbucket-25253 (5/4/2011)
Jeff Moden (5/3/2011)
mtassin (5/3/2011)
WayneS (5/3/2011)
ChrisM@home (5/3/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
May 4, 2011 at 7:05 am
Gianluca Sartori (5/3/2011)
I got it working after a long fight with permissions, policies, and registry keys.
...and I thought that a DBA didn't need to be...
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 11:48 pm
Viewing 15 posts - 2,056 through 2,070 (of 7,499 total)