Viewing 15 posts - 3,556 through 3,570 (of 7,499 total)
use at your own risk 😉
You could use this to start with
Select 'Delete from [' + TABLE_CATALOG + '].[' + TABLE_SCHEMA + '].[' + TABLE_NAME + '] where...
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
July 23, 2009 at 4:23 am
BP is always to specify the database name you want to connect to (don't rely on the logins default database ! A sql instance can host multiple databases !)
Check out...
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
July 23, 2009 at 3:52 am
abhishek.c1984 (7/23/2009)
I have just executed the query in SQL Server 2005, it worked fine...but the database connection was broken
-------
Nonqualified transactions are being rolled back. Estimated rollback completion:...
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
July 23, 2009 at 1:31 am
abhishek.c1984 (7/22/2009)
So before going ahead, i need to close the active connections and then proceed further.......So, in such cases is it possible to make forced backup 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
July 22, 2009 at 6:59 am
with Sp_lock it will provide you the spid that has the lock.
To get to see the last statement that spid is executing,
select est.text
FROM sys.dm_exec_sessions ES
left join sys.dm_exec_requests ER
on...
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
July 22, 2009 at 5:52 am
Which driver are you using ?
Are you (or the driver by default) using implicit transactions ?
A backup/restore operation cannot be incapsulated with a transaction.
If a restore fails, 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
July 22, 2009 at 5:28 am
be sure to implement FK-indexes for the columns KeyWorkerId and CoWorkerId.
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
July 22, 2009 at 3:45 am
maybe you can even skip the isAgency column.
...AgencyName,
IsAgency ...
Implement a constraint to check on the combination coworkerid and agencyname
if coworkerid not is null, agencyname must be null
and the other way...
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
July 22, 2009 at 3:16 am
Things like dbmirroring, dbMail, or Service broker may cause msdb to grow.
e.g.
SELECT @@servername as Q_001_MSDB, COUNT(*) as nRows from msdb.sys.transmission_queue ;
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
July 22, 2009 at 2:06 am
I have only done some tests with DBmirroring.
I don't have actual experience with many mirrored databases of the same insatnce.
I just wanted to let you know MS customer advisory team...
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
July 19, 2009 at 11:20 am
I was just checking my mail and had a couple of minutes spare for SSC :hehe:.
Most of the times mail and SSC come together.
Have a nice (remaining)weekend.
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
July 19, 2009 at 11:13 am
Indeed, but the uncleanly "detached" files will only be a part of the problems.
Everything performed a instance level , logins, jobs, end points, instance level triggers, ... will have to...
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
July 19, 2009 at 11:10 am
You need to check on the rename server procedure !
SQLServer knows its own name, so you need to remove the old and add the new one.
http://msdn.microsoft.com/en-us/library/ms143799.aspx
stand alone instance
sp_dropserver
GO
sp_addserver ,...
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
July 19, 2009 at 10:07 am
Which one did you pick ?
- the ddl trigger ?
- least privileged ?
- both ?
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
July 18, 2009 at 8:54 am
16% free. but it represents 16GB.
How big is your biggest table (ix included if they reside in that datafile) ?
Why ? if you rebuild that table, you may need...
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
July 17, 2009 at 2:03 pm
Viewing 15 posts - 3,556 through 3,570 (of 7,499 total)