Viewing 15 posts - 91 through 105 (of 508 total)
Joining tables across servers is generally a bad idea. It is EXTREMELY slow with more than just a handful of rows in the tables on each side.
If you are...
October 10, 2011 at 12:08 pm
Dave Ballantyne (10/6/2011)
vince_sql (10/6/2011)
You can do cumulative totals using a correlated subquery.
SELECT id,dt,amt,(SELECT SUM(amt) FROM #t b WHERE a.id = b.id AND a.dt >= b.dt)
FROM #t a
I would very much...
October 7, 2011 at 12:13 pm
Actually Access treats 0 as false and -1 as true.
Todd Fifield
October 5, 2011 at 11:56 am
Just create a table in which to dump the variables passed into the procedure with a little extra data to make it easier to eyeball. If the procedure looks...
October 3, 2011 at 1:40 pm
The only reason to specifically include the clustering key in another index would be that's how you wanted to seek on the index. That means you are seeking on...
October 3, 2011 at 12:42 pm
Evil Kraig F (9/30/2011)
CELKO (9/29/2011)
Learn a few basics, be polite and we will talk after you re-postPot, this is the kettle. I'd really like to discuss your current hue...
Now...
October 3, 2011 at 11:45 am
Something is going on that you don't know about. When something is going on that doesn't make sense, it's time to examine your basic assumptions.
You can fire up the...
September 29, 2011 at 9:53 am
Grant Fritchey (9/27/2011)
September 28, 2011 at 4:14 pm
pwalter83 (9/27/2011)
Ninja's_RGR'us (9/26/2011)
pwalter83 (9/26/2011)
Ninja's_RGR'us (9/23/2011)
What's the value you have in that variable?@Commoditylike
The value comes from a column called Commodity.
I meant when you run the query and it fails to return...
September 28, 2011 at 2:25 pm
Putts,
As Grant pointed out it's usually best to only return the columns actually needed by the front end. It reduces network IO between SQL Server and the application.
However, it's...
September 27, 2011 at 11:31 am
Steve,
There are 2 other methods to do this. I suggest you read this article by MVP Gail Shaw to become fully rounded on the subject:
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
Todd Fifield
September 27, 2011 at 11:01 am
To further what Sean pointed out you could do it with INSTEAD OF triggers. If it won't break your SLA with the vendor.
Here's an example:
CREATE TABLE T1
( T1ID INT...
September 24, 2011 at 12:20 pm
Ninja's_RGR'us (9/21/2011)
tfifield (9/21/2011)
Remi,I can think of a couple of ways to do this using file names or dates. I'm curious as to how you do it?
Todd Fifield
Something like this...
September 24, 2011 at 10:58 am
Remi,
I can think of a couple of ways to do this using file names or dates. I'm curious as to how you do it?
Todd Fifield
September 21, 2011 at 3:44 pm
Ninja's_RGR'us (9/20/2011)
tfifield (9/20/2011)
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...
September 20, 2011 at 8:21 pm
Viewing 15 posts - 91 through 105 (of 508 total)