Viewing 15 posts - 10,081 through 10,095 (of 39,769 total)
Sioban Krzywicki (1/21/2015)
The question is if I can get my name changed on the articles I've written here. : -)
Sure thing. I think if you change your author name, it...
January 21, 2015 at 8:47 am
I don't like those naming conventions because they can change. Imagine someone says create PO numbers. You do intPO or something. Then a year down the road you find you...
January 20, 2015 at 3:51 pm
It would be good to see something like:
Original data
Cust Year Period FLIGHTHRSSUM LATEFEESUM EXCHFEESUM
----- ---- ------ ------------ ---------- ----------
A 2015 1 ...
January 20, 2015 at 2:21 pm
In terms of moving data, I know this link is Azure, but I'd think some of this would be similar in Amazon. I'll have to try it at some point:...
January 20, 2015 at 10:45 am
I tend to agree with Solomon here. The .NET tools are widely known, though perhaps not by DBAs. This is advanced tooling, and rather than have MS build something else,...
January 20, 2015 at 9:36 am
For those of you concerned about costs, if you paid by the CPU/RAM instead of standard/enterprise, would that work?
Let's say that it was something like $800/core and $100/8GB of RAM....
January 20, 2015 at 9:35 am
Eric M Russell (1/20/2015)
January 20, 2015 at 9:30 am
Hmmm, nothing we have set up for a discussion, but probably need it. I know it's working in 2012 (just tested). Will fire up a VM and check 2014.
Which version...
January 20, 2015 at 9:30 am
david.gugg (1/20/2015)
January 20, 2015 at 9:28 am
If you start to extend this to lots of potential items, then a trigger grows to slow things, or cause issues. A trigger might work in production, but potentially if...
January 20, 2015 at 8:59 am
Michael Meierruth (1/20/2015)
Had a good laugh 😀 watching you and Grant performing those competitions showing who can type fasted - with or without SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt.
😀
January 20, 2015 at 8:42 am
Apologies. Not sure why I had numeric as 17 and not 38 for the scale.
Points awarded back, answers changed.
January 20, 2015 at 8:38 am
In T-SQL, you'd use dateadd, with getdate() like this:
dateadd(dd, -1, getdate())
to get yesterday. In SSIS, if you are doing this, you'd use the Expression language, it's slightly different.
DATEADD("dd", -10,...
January 19, 2015 at 11:30 am
Megistal (1/19/2015)
Steve, if you want to get more time for something else (or just getting plain lazy), automate stuff 😀
😛
January 19, 2015 at 10:07 am
I'd tend to use odbc/ado/oledb to try a connection from code and see if it works.
If you're debugging manually, copy sqlcmd.exe over there and run it.
January 17, 2015 at 11:08 am
Viewing 15 posts - 10,081 through 10,095 (of 39,769 total)