Viewing 15 posts - 2,506 through 2,520 (of 7,499 total)
Please read my little article regarding the use of logon triggers for this purpose !
There may be some considerable down sides !!
Scope: The drastic caveat with Logon Triggers.
http://www.sqlservercentral.com/articles/Administration/64974/
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
January 3, 2011 at 3:08 pm
Hey... you have compare 8 !
Just script your full db.
Edit the sqltext and alter all current filegroup to NEWfilegroup.
Save the file
Use compare8 to generate your migration script comparing the db...
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
January 3, 2011 at 7:08 am
how about using a staging table to prepare all your new data and only at the very last merge the data into your target table ?
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
January 3, 2011 at 6:15 am
maybe even start with this script that can help you with your inventory and scripts.
Just add that part to use the new location.
http://www.sqlservercentral.com/Forums/FindPost368929.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
January 3, 2011 at 5:49 am
DMV sys.dm_db_index_usage_stats contains the usage info you need.
BIG REMARK from BOL:
The counters are initialized to empty whenever the SQL Server (MSSQLSERVER) service is started. In addition, whenever a database...
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
January 3, 2011 at 5:43 am
If that occurs with our backup jobs, it's always an xcopy still trying to copy the file to a safe zone.
We examine why that copy is taking that...
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
January 3, 2011 at 5:32 am
I would first run :
dbcc updateusage ('yourdb') with count_rows
and re-inspect the figures after that.
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 31, 2010 at 6:08 am
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.
Congratulations for the 10K barrier.
Thank you for your support, 10000...
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 31, 2010 at 6:01 am
euhm, no ... still on 32 bit xp :blush:
Does msdtc have a 64-bit version too, and is that the version you configured.
Did you configure both versions ?
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 30, 2010 at 10:51 am
as you know, the value null is not NULL !
declare @var varchar(128)
set @var = 'NULL'
if @var is null
begin
select @var, ' it is indeed null 1'
end
else
begin
select @var, ' it 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
December 30, 2010 at 6:35 am
It works on my laptops sql2000 (SP4) instance ..
begin tran
SELECT *
FROM [ws20098002\SQL2000PE].pubs.dbo.employee
commit tran
must be a config issue.
Can you doublecheck your dtc configuration and firewall...
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 30, 2010 at 6:05 am
is tcp\ip enabled for the 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 30, 2010 at 5:49 am
If you have ssms on that server, can you just start it.
Do not connect to the server yet!
so cancel the connect popup.
Then click "new query" and then connect using 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
December 30, 2010 at 4:59 am
- please provide sql2005 version info ( @@version )
- is this an upgraded db (from 7 or 2000) ?
(and did you perform post migration maintenance ?)
- can you run dbcc...
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 30, 2010 at 4:51 am
1) why are you using 4-part naming ?
You should just connect to the correct sql-instance and db and use two part naming.
2) did you enable and configure msdtc at 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
December 30, 2010 at 4:45 am
Viewing 15 posts - 2,506 through 2,520 (of 7,499 total)