Viewing 15 posts - 41,611 through 41,625 (of 49,552 total)
Steve Jones - Editor (1/18/2009)
I've scheduled re-runs on Fridays for a few months since content has been a touch thin. Hint, hint, new articles anyone?
I've got one that's getting tech-reviewed...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 9:17 am
You can write one yourself, based off sys.tables, sys.column and sys.types. It's not difficult, thought it is a it tedious to write (I don't have one, but I did similar...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 8:48 am
You need to give more information here. A lot more.
What's your manager talking about migrating?
SQL CLR is the CLR (the common language runtime) within SQL Server (2005+). It allows...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 6:18 am
Of course, as long as you're in full or bulk logged recovery and nothing has truncated the log since the diff.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 3:09 am
No.
Insert the data into a temp table that has an identity and then select with the identity column.
Please post SQL 2000-related questions in the SQL 2000 forums.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 2:54 am
When was the previous log backup? Was there anything that broke the log chain since then (switch to simple, truncate only)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 2:53 am
Please don't start new threads for existing questions. It just leads to duplicate replies and wastes people's time.
Asked and answered - http://www.sqlservercentral.com/Forums/FindPost638856.aspx
No replies to this thread please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 2:52 am
RBarryYoung (1/17/2009)
Hey, I just read it. That is a great article!
Agreed. Steve, can you republish this?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 2:49 am
What type are they at the moment?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 2:38 am
What kind of CLR stuff do you have? Just asking in general about migrating it's a pretty vague question.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 2:37 am
matsinopoulos (1/18/2009)
Hi,I was wondering whether there is any similar construct in SQL Server 2008 with what one has in Oracle as ROWTYPE.
No. You'll have to do it the hard way.
Aside,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 2:37 am
RBarryYoung (1/17/2009)
This being an ORDER BY on the outermost SELECT, it seems that it is guaranteed to be so sorted.
Ummm. This is an odd case. I chatted with one of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 2:35 am
Jeff Moden (1/17/2009)
Heh... first, you do realize that I was spoofing on him, right. 🙂 Just gotta make sure.
It was prettyn obvious
And I agree... correct answer for the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 2:23 am
kiransuram19 (1/17/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 2:22 am
Paresh Prajapati (1/17/2009)
Anywany if u want to talt log backup with truncation , Please take full backup of database after that..
I said that.
GilaMonster (1/17/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2009 at 2:09 am
Viewing 15 posts - 41,611 through 41,625 (of 49,552 total)