Viewing 15 posts - 13,816 through 13,830 (of 39,899 total)
Each time you post, you can set a new default.
May 19, 2012 at 8:29 pm
Note that if you have the R2 or 2012 versions, they won't attach.
I tend to like the 2008 version since it has the Filestream stuff. If you don't need that,...
May 18, 2012 at 3:58 pm
SQLRNNR (5/18/2012)
In Boston now getting ready for SQL Sat 142.If you are close by, come check us out.
Enjoy! I'll be speaking downtown in Denver tomorrow at the Rocky Mountain Tech...
May 18, 2012 at 1:48 pm
Brandie Tarvin (5/18/2012)
I am so tempted to do the Holy Grail joke as a QotD.Steve, would you approve such an animal if I sent it in?
Perhaps for a holiday. Can...
May 18, 2012 at 12:23 pm
TravisDBA (5/18/2012)
Steve,
Agreed, 12 is manageable for most users I think. 20 is just overkill and it is the default. You must also keep in mind that many of our users...
May 18, 2012 at 11:19 am
No way. What you are doing is saying, can I restore T-logs at any point in time to my production databases. That's what an OS snapshot is.
The answer is no....
May 18, 2012 at 10:57 am
Ray K (5/18/2012)
Let's see . . . how about the following hypothetical situation . . .
You're the manager....
May 18, 2012 at 10:43 am
Gazareth (5/18/2012)
Brandie Tarvin (5/17/2012)
Hey, Steve, can you change the birth year in my profile to read 1776, please?😀
I wonder if he could change it to 1752?
Not 1999?
("we're gonna party like...
May 18, 2012 at 10:40 am
Hmm, I thought that Compare would work against a script. I see an option against source control, which doesn't help, but you can compare against a backup.
If you copied your...
May 18, 2012 at 10:34 am
The load would be when your backups run on the primary. What is the workload like?
Check basic perfmon (CPU, pages/sec, disk IO) while people are working, and then when...
May 18, 2012 at 10:26 am
Sorry, SQLSophist, this slipped through the cracks.
Please take it if you want.
How about two child packages that do
- load a simple file (assume an Excel file, simple format, same name,...
May 18, 2012 at 10:25 am
sebmr2 (5/18/2012)
May 18, 2012 at 10:17 am
TravisDBA (5/18/2012)
May 18, 2012 at 10:16 am
baxterr (5/18/2012)
May 18, 2012 at 10:15 am
My apologies.
BULK INSERT is a T-SQL command that essentially does what the command line tool, bcp, does.
BCP - http://msdn.microsoft.com/en-us/library/ms162802.aspx
When in doubt, pop open books online and search. The www version...
May 18, 2012 at 10:13 am
Viewing 15 posts - 13,816 through 13,830 (of 39,899 total)