Viewing 15 posts - 31 through 45 (of 117 total)
david_wendelken (9/22/2010)
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...
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....
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...
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. ...
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.
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. ...
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...
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...
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. 🙂
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...
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...
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...
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...
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...
June 23, 2009 at 7:28 pm
Viewing 15 posts - 31 through 45 (of 117 total)