because I want find the truth . I want to dig out root cause instead of blindly throwing out resources . Simply put , I don’t want to be fooled...

hi Steve, when restore tde enabled backup to the dest instance, say there are multiple tde certificates on the dest instance. Do I need to specify which certificate to be...

Is there anyway to know what resides in Extent 1 ? if it's not data pages?

 

thanks

thanks. It was vendor supported application. We are not allowed to change any query though

to delete a sqllogin/job that is not on primary replica but still no secondary replica. The trick is to check if logins/jobs from secondary replica exist in primary, if they...

• This reply was modified 4 years, 5 months ago by  huishi.ca.

Thanks author for sharing this unique technique. As a techie guy, it was always pleasure to know new idea to tackle some common problems. For this reason, it is not...

I know it's an old thread. If you really want to shrink your datafile and release it back to disk, the fastest way would be create a new empty datafile...

hi all : 
 Best solution I found is to update configuration table directly

For example: you've added a new user variable called DummyVariable (Int32, initial value is 9999) into...

hi Craig, nice posting. From my experience, all job description are for ideal candidates which

never exist in reality. If the job descriptions fits 60% of what I am...

hi ricardo, have you utilized Waitfor Delay to try to avoid concurrency locking issue?

We are a BIG DATA company as well and have similar requests pulling data from...

ricardo_chicas (8/20/2010)

---

Ok lets do this, forget about the original problem

what I really want to know is for a suggestion on what is the best way to retrieve large amount of...

We are actaully having the similar request. Our database stores big data.

200G data daily and we need to retrieve data on weekly basis for reporting purposes that is roughly around...

awesome article , however, I have a different scenario. What about the source and target tables are really large?

close to 1 billion records? I am not sure if it's...

Hi Jeremy:

The query below would do the same trick

WITH SOH AS (

select salespersonid,subtotal

from Sales.SalesOrderHeader

where OrderDate Between '1/1/2003' and '1/31/2003'

and salespersonid is not null)

select S.SalesPersonID, sum(SOH.subtotal) as...

Table a

a1 a2

====

1 10

2 20

Table b

b1 a1

=======

2 2

20 1

query:

select *

from a

left join b

on a.a1 = b.a1

and a.a1...