Of course the media wants him gone! News published by consumers for consumers directly threatens the centralized (hierarchal) model the media depends on to make a profit. Now is not the place to debate whether the US media is "White House friendly" or not, but I'm sure that's not the issue.Anybody read "Snowcrash"? Remember the […]
2005-03-17
Thanks for the correction, Hans. I never knew there was a difference. Have to extend my reading material.
2004-07-13
declare @sql varchar(1000), @col_name varchar(10), @orderby varchar(10) set @col_name = 'column' set @orderby = 'desc' set @sql = 'SELECT c1,c2,c3,c4,c5,c6 INTO #emp_temp1 FROM #emp_temp order by ' +@col_name+' '+@orderby print @sql exec (@sql)
2004-06-17
We have a database that consists of a number of static tables, several tables that are rebuilt from scratch every night, a couple of SP's and a gazillion views. Currently it resides on a old SQL Server (old hardware, current software) and I'd like to migrate it to a newer High-Availability Clustered SQL Server environment our […]
2004-04-06
1 reads
You should also check TempDB as it will be growing to support the indexes during the inserts.Steve Hughes, Magenic Technologiessteve.hughes@magenic.com
2004-01-22
2003-07-29
1 reads
You will have to build a distributed transaction. See Books Online for "BEGIN DISTRIBUTED TRANSACTION".
2003-07-29
quote: Something like this (Check it out in BOL): update <master_Table> set col1 = <temporary_table>.col1, col2 = <temporary_table>.col2 .... from <master_table>, <temporary_table> where <master_table>.<primary_key> = <temporary_table>.<primary_key> I don't think you acutally need the exists statement as the join has the same effect - i.e. selects existing rows. Cheers David
2003-07-25
quote: What difference does it make if the rights are explicit? The user still requires them. Yes and no. We can go into the semantics about whether or not a user requires them or not. Really it's a point that there's no reason to argue about. Every login has access to master. Even if I […]
2003-07-14
The difference originates from the use of the GROUP BY clause. In your first query, SQL Server will build the complete result set, gathering all data for each and every f.fund and f.fund_id. Once it has the complete set, it will start removing all duplicates from it. In the second one, SQL Server will use […]
2003-06-30
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers