Viewing 15 posts - 31 through 45 (of 118 total)
david_wendelken (9/22/2010)
--Paul Hunter
September 22, 2010 at 8:32 am
Is this the same FootPrints that is used for tracking trouble tickets?
Yep, that's the one. It's an OK app from the users perspective (I guess) but deserves all the...
--Paul Hunter
July 25, 2010 at 3:42 pm
Two thumbs up. We have an application (FootPrints) that we wont consolidate onto our primary SQL cluster because they insist on using the SA account for their database interaction....
--Paul Hunter
July 24, 2010 at 4:44 pm
I’ll pile on to the “favor schemas” with:
•Organization- I have multiple departments (marketing, accounting, hr) / applications (crm, rpt.) that I support. Being able to group them in a...
--Paul Hunter
June 22, 2010 at 8:22 am
I use schemas to make separate logical divisions within a database to partition off common functionality. I’ll also create a file group to hold data for some schemas. ...
--Paul Hunter
May 9, 2010 at 11:59 am
Steve-3_5_7_9 (4/9/2010)
SQLCompareSQLDataCompare
Ultraedit
SSMS
SQLServerProfiler
Yes to those, PowerShell and and a few utilities I wrote myself.
--Paul Hunter
April 9, 2010 at 7:23 pm
Like Steve, it gives our organization one more DBA opportunity so, it's not all bad. I haven't drunk the kool-aid on this product but I do see potential. ...
--Paul Hunter
October 29, 2009 at 7:38 am
Sounds like a good plan. Do a tool comparison but don't select a "winner" because that's a matter of preference. Then drill in with a how to on...
--Paul Hunter
September 13, 2009 at 3:37 pm
Thanks for the kind words. I'm in the process of building a utility that will read the file and do a sample "load" based on the format file. I...
--Paul Hunter
August 18, 2009 at 7:52 pm
Looks like I need to re-read my comments and use spell check before I post to the SQL Server Central. 🙂
--Paul Hunter
August 14, 2009 at 6:27 am
Nice treatment of an unfamiliar topic. I had figured out most of what the syntax/convention was before reading this but didn't know it had a name and defined rules.
<opinion...
--Paul Hunter
August 13, 2009 at 7:30 am
DCDBA (7/31/2009)
How about this:CREATE FUNCTION dbo.fGetDateTimeString
(
@dt datetime
)
RETURNS varchar(12)
AS
BEGIN
RETURN Convert(varchar(8), @dt, 112) + Replace(Convert(varchar(5), @dt, 114), ':', '')
END
DCDBA is the winner.
I ran the original code vs the...
--Paul Hunter
July 31, 2009 at 9:26 am
I liked the code sample. I cleand it up by removing unused/unneeded variables, unneeded columns and tightend up on the error and loopin logic. Hope you approve of...
--Paul Hunter
July 7, 2009 at 10:32 am
Maybe I went blind last night while typing in the code..... nope, no blindness. Bear, where did you see the cursor? I looked under every letter and couldn't...
--Paul Hunter
June 24, 2009 at 8:21 pm
hmmm... the solution provided by "bear in a box" looks very Oracle-ish. I believe MS & Oracle spend HOURS trying to figure out how to make their competitors code...
--Paul Hunter
June 23, 2009 at 7:28 pm
Viewing 15 posts - 31 through 45 (of 118 total)