Viewing 15 posts - 91 through 105 (of 1,183 total)
SQL will use the index if it deems it helpfull. In other words, "no action required"
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 1, 2012 at 1:03 pm
Add 1 month to the start date, and subtract 1 day. 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 1, 2012 at 11:53 am
Resender (10/31/2012)
Jason Selburg (10/31/2012)
Luis Cazares (10/31/2012)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 31, 2012 at 10:46 am
Luis Cazares (10/31/2012)
I'm thinking...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 31, 2012 at 9:39 am
The MERGE command is available in 2008 and beyond.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 31, 2012 at 9:39 am
Without getting deep into your question, would the MERGE statement be of any help.....?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 31, 2012 at 9:32 am
Here's a "poor man's source control" I wrote/found/modified a few years back. (In all honesty, I can't recall how much of this was "found" on the internet and how much...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 26, 2012 at 1:34 pm
What exactly are you trying to accomplish? Delete any workstation ID's that dont exist in your table?
If so ....
DELETE FROM W
FROM tbl_Workstations AS W
LEFT JOIN...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 24, 2012 at 1:42 pm
I'm in agreement with you. Another way to think of it is, why would you put a table of contents in a 1 page "book"?
Sql Server will ultimately pull the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 24, 2012 at 9:05 am
aditya.anita.moitra (10/12/2012)
I am in the same situation to implement Data Driven Subscription to a File Share while we are using SQL Server 2008 R2 Standard Edition. I'm really interested in...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 12, 2012 at 11:50 am
That's pretty odd Jeff. One would think that "gem of sql code" would be at the top of the list.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 3, 2012 at 12:40 pm
brendan woulfe (10/3/2012)
Apparently my google skills have failed me. Thanks Jason....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 3, 2012 at 11:51 am
Try searching this sight for "Best of SQLServerCentral" and only show articles.
http://www.sqlservercentral.com/search/?q=Best+of+SQLServerCentral&t=a
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 3, 2012 at 11:36 am
Good grief Joe, did you forget to take your meds this morning? You complain about the rudeness of the OP, look at your response. Talk about rude!!!
+1
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 3, 2012 at 9:48 am
Just a possibility, but read up on "parameter sniffing".
Also, I've found that CTE's are generally poor performers when dealing with large result sets. In those situations, I'd suggest using temp...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 3, 2012 at 9:04 am
Viewing 15 posts - 91 through 105 (of 1,183 total)