Viewing 15 posts - 15,271 through 15,285 (of 39,970 total)
Congrats, Jeff! I'll owe you a beer at PASS.
September 14, 2011 at 8:33 am
SQL Kiwi (9/13/2011)
I don't disagree at all; though that so many professional DBAs don't 'get' partitioning (a new feature in 2005!) is a bit depressing. Luckily, it seems 'commodity' DBAs...
September 14, 2011 at 8:31 am
The app definitely needs to be in the cloud, or it needs to be mindful of bandwidth.
Regarding combining data sets. I can think of a few ways to do this....
September 14, 2011 at 8:27 am
GSquared (9/14/2011)
September 14, 2011 at 8:23 am
Sorry, corrected my statement. I meant to say lower charges for current rather than historical data.
Jo Pattyn (9/13/2011)
September 13, 2011 at 4:26 pm
Nidhi G (9/13/2011)
This is not for queries.. It is related to table design...Thanks
If so, what is the issue? SQL doesn't care where you have these columns stored. It isn't...
September 13, 2011 at 3:33 pm
Let's another thread for a debate on that. I'll open one up in this forum.
http://www.sqlservercentral.com/Forums/Topic1174524-373-1.aspx
September 13, 2011 at 3:32 pm
If this is for queries, then you can do this as well:
select
Fname
. Lname
, DOB
, Age
, City
, Country
from Mytable
If its' for...
September 13, 2011 at 12:00 pm
You can right click in the upper left cell of the headers in results and select "select all" and then "save as". You'll get a CSV loadable into Excel.
September 13, 2011 at 11:58 am
I like Flo's approach better since it allows you to better error handle things and I think dynamic SQL is harder to read for anyone else following in your work.
September 13, 2011 at 11:57 am
I am with Gail. A backup of the system, and SQL binaries, assumes that those are static. But those binaries get information from the system database in order to start....
September 13, 2011 at 11:22 am
Does this historic data change?
If not, you can do this and put it in a separate filegroup. That potentially allows you to recover the primary production data quickly and restore...
September 13, 2011 at 11:20 am
You are welcome. As soon as I started working in environments with other DBAs / developers, we made that switch since code would be formatted differently on different machines.
September 13, 2011 at 8:36 am
New building looking good for the horses:

September 13, 2011 at 8:35 am
Viewing 15 posts - 15,271 through 15,285 (of 39,970 total)