Viewing 15 posts - 15,736 through 15,750 (of 39,921 total)
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
The thing is we can't see you data. Can you post something that builds a table and populates it with sample data?
Something like
Create tableA
( ID int
, ColA varchar(10)
)
go
insert TableA...
June 27, 2011 at 10:04 am
Varies quite a bit, suspect that people are just busy this week getting ready for your vacation.
June 27, 2011 at 9:15 am
this might help you: http://www.sqlservercentral.com/articles/powershell/73288/
Powershell is a command line environment with SQL 2008 and newer Windows OSes. You can invoke the command line and then execute scripts, similar to how...
June 27, 2011 at 9:04 am
Why don't you want to join with the calendar table? Do you somehow think this is more efficient? Likely it's not if you plan on running a series of calculations...
June 26, 2011 at 12:47 pm
Viewing 15 posts - 15,736 through 15,750 (of 39,921 total)