Viewing 15 posts - 14,716 through 14,730 (of 39,919 total)
I'd use David's technique for a quick count.
Is this something that runs often, or just an ad hoc type report? If the latter, then select count(*) from (subquery) makes sense.
December 19, 2011 at 9:58 am
Stefan Krzywicki Posted Today @ 10:55 AM
Those of you who have been talking about the first machines you used in the industry, what was it that got you to that...
December 19, 2011 at 9:34 am
GilaMonster (12/19/2011)
I don't think I should say anything about when I started, or there may be overripe pawpaw coming in my general direction.
You're just a kid, though since you can...
December 19, 2011 at 9:33 am
You can use a DDL trigger to capture the event. Here's a sample:
http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes
The eventdata doesn't have the machine name, but it will have the login name
December 19, 2011 at 9:28 am
Do you have a connection to the server in any way? If you can connect as an admin, you can do a NET STOP on that machine's services.
December 19, 2011 at 9:27 am
Well, I started in '67. Breathing, that is. I was lucky enough to start playing with computers in '78 and we actually had keys to punch, and tapes to store...
December 19, 2011 at 9:01 am
The upgrade advisor isn't applicable for an OS upgrade, only a SQL one.
There shouldn't be any issues with your OS upgrade, but take backups, move them off the machine, just...
December 19, 2011 at 8:54 am
We are still looking for an article for SQLServerCentral on this.
December 19, 2011 at 8:51 am
jcrawf02 (12/16/2011)
December 16, 2011 at 8:52 am
yes
December 15, 2011 at 12:37 pm
Please start a separate thread for a new question, and also post some sample data and table DDL. Your description of the problem doesn't make enough sense without an example.
December 15, 2011 at 11:33 am
The subscriber is always online.
What you want to do is send the clients to the secondary. This is a manual process. You can do it a few ways, but it...
December 15, 2011 at 9:05 am
So only one row per date?
Easy to do
if not exists
( select cut_date from test where cut_date = @cut_date
)
Insert into dbo.test
select
@cut_date,
...
December 15, 2011 at 9:03 am
Do you have automatic failover? Are you expecting people to work off the mirror while the primary one is down? If so, account for the backup and restore to fail...
December 15, 2011 at 8:59 am
Viewing 15 posts - 14,716 through 14,730 (of 39,919 total)