Viewing 15 posts - 151 through 165 (of 820 total)
Shawn Richards (8/28/2013)
ATBCharles Kincaid
August 28, 2013 at 6:19 pm
I thought that there would be a lot of comment about this. Good.
I have worked with technically competent folks of both genders. Some more competent than others. ...
ATBCharles Kincaid
August 28, 2013 at 10:34 am
raju400 (7/25/2013)
...
i need to send only latest file to ftp site everyday not all of them ??? im new bie could anyone help me to sort this issue???...
ATBCharles Kincaid
July 25, 2013 at 9:02 am
Jeff Moden (7/15/2013)
jennym (7/15/2013)
ATBCharles Kincaid
July 16, 2013 at 7:58 am
There are many ways to solve a problem. Some are better suited to situations than others.
I think that the point of the article was to teach about recursive CTEs.
ATBCharles Kincaid
July 10, 2013 at 8:09 am
Great article. I did spot one tiny thing though. You said:
If you expect to have a list with more than 100 values ...
That is a bit misleading. ...
ATBCharles Kincaid
July 9, 2013 at 8:47 am
James A Skipwith (1/1/2013)
... Glad you liked the article. ...
It was a great inspiration. I used this for a while and then made some improvements also. First I...
ATBCharles Kincaid
January 2, 2013 at 8:37 am
I like the idea of putting something like this as a task in a plan. This is dynamic in that it gets new databases without me having to do...
ATBCharles Kincaid
December 7, 2012 at 9:06 am
Great script. Thanks.
I added:
ORDER BY HeapIndex DESC, t.name
In that way the ones that I need to work on are at the top of the list. It's not so...
ATBCharles Kincaid
November 26, 2012 at 11:04 am
Great script. Thanks for posting this. Often backups don't get done because it's too hard. This will help a lot. Folks should put this in place...
ATBCharles Kincaid
November 21, 2012 at 9:09 am
Sean Lange (10/2/2012)
Or even better, just drop the prefix entirely. Object prefixes are one of my biggest pet peeves.
I would agree with you except for name collision. My bet...
ATBCharles Kincaid
October 2, 2012 at 8:30 am
Diogy (10/2/2012)
I'm not sure of the purpose of building views out of main tables programmatically. 😎
There are environments where direct access to tables by user application is prohibited but read...
ATBCharles Kincaid
October 2, 2012 at 7:22 am
This is not a problem unique to SQL 2012 but is more generic design. Even so ...
The "mapping" table is a great approach. You would have identities from...
ATBCharles Kincaid
September 27, 2012 at 7:38 am
I can see many uses for it. I can also see the two at sign notation carring on the "tradition" of temp tables.
Conversly would name spaces be better for...
ATBCharles Kincaid
September 27, 2012 at 6:53 am
Sigerson (9/25/2012)
"...As I read in another post in this forum, from Abraham Lincoln, "If I had 8 hours to cut down a tree, I'd spend 6 hours sharpening the ax."
Get...
ATBCharles Kincaid
September 25, 2012 at 9:56 am
Viewing 15 posts - 151 through 165 (of 820 total)