Viewing 15 posts - 1 through 15 (of 129 total)
Service broker.... ?
Qouting Shah_mm from here: "But after I deleted the service broker queue which was not used, it cleaned up automatically. Not suer what triggered that."
Other Google results seem...
June 11, 2008 at 6:58 pm
I don't know whether this is useful information but with a clustered SQL server the second instance is made active and should you have an existing connection from application/sql query...
June 11, 2008 at 6:48 pm
Dunno. Guessing here but does this report include index space used ?
(sudden attack of laziness is preventing me from checking this myself)
June 11, 2008 at 6:30 pm
Read this ?
SQL Server 2005 Books Online (September 2007)
How to: Use the Dedicated Administrator Connection with SQL Server Management Studio
Microsoft SQL Server 2005 provides a dedicated administrator connection (DAC). The...
June 11, 2008 at 6:17 pm
Dead simple. Note current time. Issue defrag command. On completion note time. Observe difference between recorded times, hey presto !
Or:
No.
June 11, 2008 at 6:09 pm
Well how certain are you that you have the correct user/password ? And if not using a SQL Server login do you have mixed mode so you can use Windows...
June 11, 2008 at 6:03 pm
IF that table comparison IS factual I would advocate we move to Oracle. We have both here and Linuxthough Oracle is hugely more costly, Oracle doesn't f**k us around as...
April 2, 2008 at 3:59 pm
Did this thread take a left turn without indicating ?
One really nice feature that 2005 has is the CLR. you can do some nice Visual Studio Managed Code function creation...
January 30, 2008 at 11:11 pm
Start looking for another job, immediately.
In the meantime just apply deny access - change the sa password to one only you know - lock the password in a safe or...
January 30, 2008 at 10:57 pm
And useful to know when an InstallShield installation fails or does not complete correctly. Removing the items allows you to retry an installation instead of having to reboot before re-installing.
October 9, 2007 at 10:07 pm
Okey Dokey. Well if you want serious. I have 10g Dev Express loaded locally and it works very well. That's about the best I can say about Oracle here.
As far...
October 4, 2007 at 4:10 pm
Shhhh....Oracle is asleep. (Or perhaps the listener has gone down again)
October 3, 2007 at 9:41 pm
We use Infra Enterprise which is way over the top for you most likely. It has all the bells and whistles - sla's, web acccess, thick client, ITIL compliant, customer...
August 8, 2007 at 9:38 pm
And watch out for two tables with the same name but different owners in the same database e.g.
dbo.ThisWillConfuseHim
jdavies.ThisWillConfuseHim
db
August 8, 2007 at 12:44 am
A battery/combustion hybrid car will show the best benefit where the driving is stop/start/short trip as versus long distance >= 60km/hr (30 mph).
Since the car cannot run forever on batteries...
May 30, 2007 at 7:47 pm
Viewing 15 posts - 1 through 15 (of 129 total)