Viewing 15 posts - 2,281 through 2,295 (of 5,843 total)
ItsDaveTime (12/13/2013)
Our scenario is this. We have a high traffic website...
December 13, 2013 at 9:05 pm
Keith Tate (12/11/2013)
and (spt.IsNextOfKin=1)or /* using OR as not ALL employees meet the three conditions */([set].IsNextOfKin=1)or
(sat.IsNextOfKin=1)
If you want one of those...
December 11, 2013 at 9:06 am
Lempster (12/10/2013)
Can you not even be bothered to type "TSQL MERGE" into your favourite search engine? Jeez...
Which, or how many, of the 297000 returns that Google brings back would you...
December 10, 2013 at 8:49 am
srikanth5868, please start a new thread for your question.
December 5, 2013 at 8:52 pm
Good on SQLServerCentral.com for stepping up publicly on this. The book give-away is just icing. Here is a very complex example I show in my SQL Server 2012...
December 5, 2013 at 8:02 am
select distinct top 100
i.invoice_id, i.buyer_code, i.submit_time, i.request_id
from
dbo.invoice i inner join dbo.invoice_adj ia on i.invoice_id = ia.invoice_id and ia.amount !=0
where
(i.detail_amount != 0 or i.tax_amount!=0)
and not exists (select 1
from dbo.invoice_detail...
December 4, 2013 at 12:00 pm
Compare the amount of data in the tables involved. Perhaps someone did some inserts or deletes that changed estimated row counts.
Verify that the queries are EXACTLY the same, and...
December 3, 2013 at 6:24 pm
SQL!$@w$0ME (11/29/2013)
Thanks a lot guys... I forgot to mention that this dev environment is a VM. Does these drive recommendations still applies even if its in vm?
Sure, but being a...
November 29, 2013 at 10:30 pm
SQL!$@w$0ME (11/28/2013)
For dev environment d: for app, e: for data, f: for log, g: for tempdb and h: for backup is it too much im asking for?
Disk letters mean...
November 29, 2013 at 6:06 am
SQL!$@w$0ME (11/28/2013)
We are planning to migrate to SQL Server 2012 from 2005. We are in the initial process of building a 2012 DEV environment in Windows 2012. Please assist...
November 28, 2013 at 8:42 am
I gave a very good talk on MERGE that you can download here: http://sqlsaturday.com/217/schedule.aspx
Note you can View All Events and open the schedule page for every SQL Saturday that...
November 23, 2013 at 3:55 pm
I am sorry Luka, but I still have no idea what you need here. Your data doesn't match the graphic you gave (which covers 2010-03-26 06:00 through 2010-03-27 06:00),...
November 21, 2013 at 4:12 pm
jcb (11/20/2013)
...(inner) joining 10 huge (well designed) tables by (tunned) indexed columns ill run smoothly.
Until you have some data value skew, in which case the probability of getting screwed increases...
November 20, 2013 at 8:52 am
Please provide a sample table with sample data and expected outputs. We can't help easily based on verbal descriptions.
November 20, 2013 at 8:50 am
Sean Lange (11/18/2013)
There is nothing wrong with your ddl. I am guessing this is on the .NET side. What does the code look like?
I concur. Run Profiler with RPC...
November 18, 2013 at 4:02 pm
Viewing 15 posts - 2,281 through 2,295 (of 5,843 total)