Viewing 15 posts - 10,996 through 11,010 (of 14,953 total)
There isn't a "best practices" rule that I'm aware of. Workloads are way too company-specific to really have a rule like that, or at least to have a rule...
February 12, 2009 at 7:43 am
The culture definitely matters more than the physical arrangement, but I like open spaces more than closed. No clausterphobia or anything like that, I just like to be able...
February 12, 2009 at 7:37 am
I built a proc at one point specifically for point-in-time restore from the production server to the test server, to have fully up-to-date data and schema, for testing migration scripts...
February 12, 2009 at 7:27 am
Awesome. Glad I could help.
February 12, 2009 at 7:21 am
Roy Ernest (2/11/2009)
February 12, 2009 at 7:01 am
I try to guage the degree of response based on how I read the question. If, for example, it looks like an interview/test/homework question, I'll simply say so and...
February 11, 2009 at 3:18 pm
Per MSDN, it's a valid selection. And, yeah, I don't think I would want to make the business case on ths one.
February 11, 2009 at 9:00 am
Per the bulletin and per some web searches, it applies to any system that has that proc, except those listed in the bulletin (2k5 SP3, 2k8, aren't affected, same for...
February 11, 2009 at 8:57 am
noeld (2/10/2009)
You can useALTER SCHEMA Trainning TRANSFER dbo.tablename;
You will lose the permissions though 🙁
Didn't know about that one. But that still leaves you with a whole database of...
February 11, 2009 at 7:19 am
I'd probably do that one with another CTE and use the Max function on the date (if you want the last one) or Min (if you want the first one).
February 11, 2009 at 7:17 am
In BIDS, in your SSIS package, create an SQL object, have it run the query and assign the results to a variable of type "Object".
Then create a For...Each...Next loop in...
February 11, 2009 at 7:14 am
Steve Jones - Editor (2/10/2009)
February 11, 2009 at 6:55 am
Viewing 15 posts - 10,996 through 11,010 (of 14,953 total)