Viewing 15 posts - 151 through 165 (of 820 total)
Shawn Richards (8/28/2013)
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. ...
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???...
July 25, 2013 at 9:02 am
Jeff Moden (7/15/2013)
jennym (7/15/2013)
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.
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. ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
September 25, 2012 at 9:56 am
Viewing 15 posts - 151 through 165 (of 820 total)