Viewing 15 posts - 15,781 through 15,795 (of 39,970 total)
In AdventureWorks, this will return the oldest record:
SELECT cc.CreditCardID, cc.CardNumber, cc.ModifiedDate
FROM Sales.CreditCard cc
WHERE cc.ModifiedDate = (SELECT MIN(ModifiedDate)
...
June 28, 2011 at 12:25 pm
SSRS should do this, setting up reports, but that might be a lot of work. However it does subscriptions in the Enterprise edition.
Failing that, are you looking to generate the...
June 28, 2011 at 12:20 pm
Robocopy may work. I used it years ago, but I believe it worked for just this kind of work.
There are lots of options these days in the cloud, but for...
June 28, 2011 at 12:18 pm
OK, so to get a list of tables that are older than that date, this works:
SELECT name
FROM sys.objects
WHERE type = 'u'
AND create_date...
June 28, 2011 at 12:16 pm
Nevyn is correct, it's hard to understand what you need. The description you've given isn't that clear as to what is needed.
You can mock up the table, but please give...
June 28, 2011 at 12:11 pm
Enjoy presenting. Couple things.
1. Breathe. Easy to race through things. Take a moment at a few spots to get a drink of water or take a deep breath and pace...
June 28, 2011 at 11:45 am
Chris,
you'd have to remind me which VAS post, but I do think that we could use more articles that push this more complex information out to people to help them...
June 28, 2011 at 11:28 am
Gianluca Sartori (6/28/2011)
A mug would have been enough, but, since I'll be unemployed in 40 days, a check wouldn't hurt. 😀
I don't have mugs or much swag at all anymore....
June 28, 2011 at 11:27 am
It sounds like you have thought things through well and I'd go with your gut.
re: mirroring: it's mostly a load of transactions issue. You can mirror 100 databases on x86...
June 28, 2011 at 11:23 am
My apologies, I was reading execution context and thinking query plan and wrote the wrong words. The intention was to test knowledge of the execution phase of the execution plan,...
June 28, 2011 at 8:36 am
If I understand your question, you want to know if you can specify the file names for multiple file backups?
This is a part of the BACKUP command. You enter the...
June 28, 2011 at 8:26 am
The links are updated in the editorial. My apologies for the issues.
They are:
http://www.engadget.com/2011/06/16/ibm-turns-100-brags-about-bench-pressing-more-than-companies-ha/
http://www.ibm.com/smarterplanet/us/en/overview/ideas/index.html?re=CS1
June 28, 2011 at 8:20 am
Two other things.
1. Is this a new database? In which case, the log has to be written with 0s, which can take a long time.
2. Instant file initialization on? If...
June 27, 2011 at 6:56 pm
sa may not have privileges to start Agent. Agent is a separate service, and controlled from Windows. The sa account is limited to just SQL Server, and any action to...
June 27, 2011 at 10:07 am
Viewing 15 posts - 15,781 through 15,795 (of 39,970 total)