SQLRNNR

Forum Replies Created

Viewing 15 posts - 18,466 through 18,480 (of 19,560 total)

RE: Building Masters In .Net Application - Lightning Fast !!!

Are you looking to migrate just an application? Or is a database migration also a part of the project?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 30, 2009 at 10:23 am

#1097557
RE: Creating Stored Procs for all tables

Just an additional option (if you already have the tool) is to use templates in ERWIN to generate the default scripts for each table.
Otherwise, the suggestions listed are very good.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 30, 2009 at 10:18 am

#1097554
RE: The beginning History of SSC...

The about us link does provide some nice info. Some of the info is a bit outdated (total number of SSC-ites etc).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 30, 2009 at 10:14 am

#1097550
RE: Master.dbo.SysColumns

Jeff - 40GB? Wow.
Good info in this thread.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 30, 2009 at 9:35 am

#1097526
RE: Today's Random Word!

Titans
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 30, 2009 at 8:31 am

#1097479
RE: Today's Random Word!

Jeff Moden (12/30/2009)
Posers (heh... I hate them and the moroffs that allowed them through the interview).
I second the notion.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 30, 2009 at 8:28 am

#1097477
RE: Are the posted questions getting worse?

GSquared (12/29/2009)
For anyone here a month or so ago, I have good news on the employment front. Starting a new job with a much better company in mid-Jan. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 29, 2009 at 10:21 am

#1097105
RE: Today's Random Word!

tubing
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 29, 2009 at 10:10 am

#1097099
RE: Incrementing Values

Nice work Jeff
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 24, 2009 at 3:29 pm

#1096418
RE: Twas the Night Before Christmas - SQL Style

Nice Job
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 24, 2009 at 3:21 pm

#1096415
RE: Question of the Day for 21 Dec 2009

necs (12/24/2009)
Typical Collation Bugs that hurt portability.
tempid - TempID
englishalpha - EnglishAlpha
Master.sys.SysColumns (should be) master.sys.columns
(I'd prefer) master.sys.columns (SQL2005 view for portability with SQL 2000)
A lot of posted SQL code...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 24, 2009 at 3:13 pm

#1096412
RE: Amit Khurana

It does not look promising that we will see any of the additional information necessary to best assist on this thread.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 24, 2009 at 3:09 pm

#1096409
RE: Is SQL 2010 in plan of MS?

Yes, it will be SQL 2008 R2. It was originally slated to be SQL 2010 - but that plan and name changed a few months back.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 23, 2009 at 1:09 pm

#1096124
RE: how to get file created date and time using xp_getfiledetails stored procedure

nitincaet05 (12/23/2009)
OK. This code runs on the server over the ASP, Not sure how to use SSIS task..
How do I convert creation_time ("173736") to time format?
17h37m36s
5:37:36 PM
HH = left(creation_time,2)
SS =...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 23, 2009 at 1:05 pm

#1096123
RE: Are the posted questions getting worse?

Better yet, lock them down so they can't do anything in the systems :Whistling:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

December 23, 2009 at 11:43 am

#1096097

Viewing 15 posts - 18,466 through 18,480 (of 19,560 total)