Viewing 15 posts - 316 through 330 (of 687 total)
First question I'd ask the powers that be is, why? That's quite a bit of work to migrate from a clustered instance to a standalone, depending on configuration and database...
February 21, 2012 at 7:40 am
Excellent! Congratulations!
How about a review of how you studied and what you thought about the exam?
February 16, 2012 at 6:42 am
Without seeing the query and table structure, I'd guess you're not grouping properly.
SELECT
count(*) totalsRecords,
CASE WHEN ResCalc.DESC IN('Other','Other Causes') THEN 'Other' END Desc,
sum(Amount) amount
FROM <table>
GROUP BY CASE WHEN...
February 16, 2012 at 6:37 am
SELECT servicename, startup_type_desc, status_desc,
last_startup_time, service_account, is_clustered, cluster_nodename
FROM sys.dm_server_services OPTION (RECOMPILE);
From someone's performance script. I'll source it when I find it again.
February 13, 2012 at 1:06 pm
GilaMonster (2/8/2012)
Why 5 schedules for the log backups? Just one schedule (every 5 minutes, all day) would be easier and less confusing if you need to restore.
What Gail said. One...
February 8, 2012 at 12:34 pm
Must be a shared disk and I've seen it requires a drive letter and won't work with a mount point (can't find a Microsoft link to confirm this).
February 8, 2012 at 9:04 am
I think your confusion is the assumption that server login = database principal (as noted by your join statement).
Logins are indeed principals but not mapped to database user principals...
January 31, 2012 at 10:00 am
wow!
That's crazy... kind of reminds me of Carlos from The Benchwarmers. When they ask for proof of age and he holds up a crumpled piece of paper with "I AM...
January 23, 2012 at 12:56 pm
Do you know how much they signed Darvish for?
And Fielder, last I heard, was rumored to be pursued by the Nationals. People here would love that. Fielder, Strausburg, and that...
January 23, 2012 at 11:09 am
so here's my test
create database [78abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwx]
ON PRIMARY
(NAME = N'78', FILENAME = N'<location>\78.mdf',SIZE = 30MB , FILEGROWTH = 1024KB )
LOG ON (NAME = N'78_log', FILENAME = N'<location>\78_log.ldf' , SIZE =...
January 13, 2012 at 12:51 pm
awesome!
Gus gets an extra point!
(I was notified of this winning reply by unwanted thread subscription notification of which I was grateful for just this one time)
January 13, 2012 at 9:15 am
Your first copy is a simple insert statement
INSERT INTO table_b (<list of columns>)
SELECT <same list of columns>
FROM table_a
For your next step, it sounds like you need a couple triggers.
An...
January 13, 2012 at 7:02 am
Interesting Sports Illustrated article discussing the steroid era and hall of fame voting. McGwire, Sosa, and Clemens will all be on the ballot next year.
HoF chairman puts the era in...
January 12, 2012 at 10:51 am
Could it be a bad install file?
Try downloading it again and see if that helps.
January 12, 2012 at 8:05 am
Viewing 15 posts - 316 through 330 (of 687 total)