Viewing 15 posts - 736 through 750 (of 2,008 total)
Off the topic, but I see two signature in your post. :w00t:
Jared
sqlknowitall.com
Thanks,
Jared
SQL Know-It-All
The one highlighted above, that link doesn't work.
Finally, My Best wishes for your new blog (nice...
December 20, 2011 at 8:59 am
I guess Yes (because it works for SSIS).
For More:
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11180
December 20, 2011 at 8:41 am
The Dixie Flatline (12/20/2011)
Whups. What I meant to say was country foundries. They even deliver mail to rural metal casters.
Every time I plan to...
December 20, 2011 at 8:33 am
First of all it’s SQL Server Central and you should not expect the answer for PL/SQL query here.
Secondly, few guys here work on multiple databases but its advanced PL/SQL (Oracle...
December 20, 2011 at 8:29 am
Daniel Bowlin (12/20/2011)
Timeout
Just-In-Time 😛
December 20, 2011 at 7:53 am
jkp2311 (12/20/2011)
@SSChasing Mays,I am using for my personal use.
i am not using for business purpose.
You could download EVAL version from Microsoft site. That’s the authentic way of doing it.
December 20, 2011 at 7:49 am
It’s a BIG chapter in itself & few guys (consultants) earn their bread & butter just because of it :-D. Please give opportunity to some of those guys, they will...
December 20, 2011 at 7:41 am
MS SQL cursor is not a well performing solution (Oracle is somewhat better in it). Please try to achieve it with set based approach.
December 20, 2011 at 6:37 am
GSquared (12/20/2011)
December 20, 2011 at 6:31 am
PaulB-TheOneAndOnly (12/20/2011)
Dev (12/20/2011)
At the end of the day, if business is asking for granular data or for an aggregation nobody thought before there is little choice but hitting...
December 20, 2011 at 6:05 am
As a quick suggestion you may modify your code to match with following...
Example:
-- JOIN based deletion
USE AdventureWorks2008R2;
GO
DELETE FROM Sales.SalesPersonQuotaHistory
FROM Sales.SalesPersonQuotaHistory AS spqh
INNER JOIN Sales.SalesPerson AS sp
ON spqh.BusinessEntityID = sp.BusinessEntityID
WHERE...
December 20, 2011 at 5:35 am
Charlottecb (12/20/2011)
Dev (12/20/2011)
Charlottecb (12/20/2011)
Since I don't know exactly what time of the day the majority of records will be loaded,...
December 20, 2011 at 5:25 am
MothInTheMachine (12/19/2011)
December 20, 2011 at 5:12 am
select t1.f1, t1.f2, ...
from table1 t1
left join table2 t2 on t1.id = t2.id
where table2.id > 0 --table2.id is null
...
December 20, 2011 at 4:58 am
Charlottecb (12/20/2011)
Since I don't know exactly what time of the day the majority of records will be loaded, I was thinking of...
December 20, 2011 at 4:45 am
Viewing 15 posts - 736 through 750 (of 2,008 total)