Viewing 15 posts - 5,956 through 5,970 (of 15,381 total)
dwain.c (1/13/2014)
Sean Lange (1/13/2014)
Of course let's not forget to include the cleanup to drop our temp tables.
drop table #DEMOGRAPHICS
drop table #CHARTATTACHMENT
drop table #NOTES_TEXTDATA
This is awesome advice. Is that in...
January 14, 2014 at 7:30 am
Here is a true story from the field that a buddy of mine shared with me yesterday.
Yesterday my supervisor sent me an email regarding a view that wasn't returning accurate...
January 14, 2014 at 7:26 am
I will make the assumption that you didn't actually read the article that was suggested. If you had you would have realized that we want is create table statements and...
January 13, 2014 at 2:44 pm
Alan.B (1/13/2014)
I will ignore your comment about suggesting that always using NOLOCK is a good idea when integrity of the results is not important.:w00t:
To be clear (and to avoid being...
January 13, 2014 at 2:27 pm
Not big on making this easy for anybody I see. Please post this as consumable data. Here is an example:
create table #Address
(
idAddress int,
idCompany int,
IdClient int,
MyAddress varchar(20)
)
insert #Address
select 1 as idAddress,...
January 13, 2014 at 12:50 pm
Skuldouggery (1/13/2014)
January 13, 2014 at 12:36 pm
In order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form of INSERT INTO statements
3. Expected results...
January 13, 2014 at 12:27 pm
Alan.B (1/13/2014)
kbhanu15 (1/9/2014)
Hi All,can any one clarify the difference between NOLOCK and WITH(NOLOCK) in sql server 2008 ?
which one is the best practice to use ?
Thanks
Bhanu
I think everyone did a...
January 13, 2014 at 12:12 pm
Skuldouggery (1/13/2014)
Sorry, does this help? Also, I followed the link that the other gentleman had for putting some data together.
None of this really helps a whole lot. We can...
January 13, 2014 at 12:05 pm
You are quite welcome. That my explanation provided some insight. 🙂
January 13, 2014 at 10:46 am
Hi and welcome to the forums. It is very difficult to provide much of an answer because unfortunately you didn't much in the way of details.
What happens if you change...
January 13, 2014 at 10:44 am
There is a LOT of low hanging fruit here for performance improvements. I would say that 36 seconds is outside of the acceptable range for a query running in production....
January 13, 2014 at 10:41 am
j-1064772 (1/13/2014)
EXCEPT was a mistake. (Also, [font="Courier New"]SELECT ProductID FROM Product WHERE NOT ProductID IN (SELECT ProductID FROM WorkOrder)[/font] also does yield the...
January 13, 2014 at 10:17 am
j-1064772 (1/13/2014)
If Microsoft deemed it necessary to add the EXCEPT command, then what are its advantages over an INNER JOIN...
January 13, 2014 at 9:42 am
Skuldouggery (1/13/2014)
I ran this query multiple times last week in my SQL Server 2005 database and it worked fine. Today, I go to run the exact same query and...
January 13, 2014 at 9:09 am
Viewing 15 posts - 5,956 through 5,970 (of 15,381 total)