Viewing 15 posts - 106 through 120 (of 508 total)
GilaMonster (9/20/2011)
tfifield (9/20/2011)
Anyone got any ideas?Todd Fifield
Drop database, start again.
You can put the DB back into restoring easy enough, but it still won;t allow another log restore.
Thanks Gail. ...
September 20, 2011 at 3:45 pm
Ninja's_RGR'us (9/20/2011)
tfifield (9/20/2011)
September 20, 2011 at 3:05 pm
Well, everything worked fine thanks to Gail. However, when we were restoring the logs we stopped one short of where we really wanted to be and then did the...
September 20, 2011 at 2:58 pm
Gail,
Thanks a lot. I'm now going to try to bail my friend out of trouble.
Todd
September 20, 2011 at 12:30 pm
Gail,
Thanks. I've actually never restored logs to a different database than the original. Is there a write up of some kind on this?
Todd Fifield
September 20, 2011 at 12:23 pm
Here's another way to do it. I find that some people forget that COUNT and SUM are also windowing functions and can be used in a partition.
declare @t table(
MasterID...
September 16, 2011 at 12:23 pm
I find as a first step that Adam Mechanic's free utility sp_whoisactive will find a good many problems right off the bat.
Todd Fifield
September 16, 2011 at 11:47 am
Looks like the APPLY method worked out for you.
Todd Fifield
September 15, 2011 at 2:16 pm
zapouk (9/15/2011)
I'm actually opposed to storing running totals in permanent tables for various reasons we can get into later.
Given the implications for me, you'd better tell me sooner rather than...
September 15, 2011 at 2:01 pm
fiddi,
I had something similar to this - missing GO statements causing a drop with no create. I finally created a little app in VB to concatenate the source files...
September 15, 2011 at 1:46 pm
I've never exported directly from SQL Server to FoxPro. I've done it several times to an Access MDB where the Access MDB is a linked server. There were...
September 15, 2011 at 11:20 am
schillingt (9/12/2011)
September 14, 2011 at 1:10 pm
It's fairly easy to convert a string into something that can be used like an IN predicate. Here's an article on it.
http://www.sqlservercentral.com/articles/T-SQL/73838/
Todd Fifield
September 14, 2011 at 12:19 pm
schillingt,
Let's make sure we all agree on what we're talking about. I've seen what are more properly called derived tables called sub-queries. A derived table is what you...
September 10, 2011 at 5:39 pm
GilaMonster (8/31/2011)
tfifield (8/31/2011)
If you really need all columns returned, then by all means use SELECT *.
Even if every single one really is needed, they should still be explicitly named. Tomorrow...
August 31, 2011 at 2:23 pm
Viewing 15 posts - 106 through 120 (of 508 total)