Tim,This is a divide and conquer case. As a guidance you can take a look at the following code Create table #TDups( Person_Id int, Role varchar(50), Dte datetime, Surname varchar(50), Forename varchar(50), Dob datetime)Insert into #TDups( Person_Id, Role , Dte, Surname, Forename, Dob) Select P.Person_ID, P.Role, P.Dte, P.Surname, P.Forename, P.Dob From […]
2005-02-25
Have you tried assigning the DEFAULT for the column that you want to populate to be NEWID()?? This way you don't have to worry about it?
2005-02-14
OK, can anyone verify this. We have now set up the same database on a different PC with 2 hard drives (Databases installed on the second drive.) Although our test has been over 48 hours, SQL seems to be handling the avalable memory on the server better than when only 1 hard drive was being […]
2005-01-28
Michael thank you for the reply.I thought i was being clear in what it was I was trying to do, however it is obvious that I was not. Let me try again..I have a set of tables that are prefixed with ae_dtnn and ae_dlnn. the ae_dt tables contain index information as well as the docid. The […]
2004-12-03
DBAs,Does anyone know of other hot standby solutions for SQL Server besides failover clustering? Are there any 3rd party tools available?Thanks.
2004-10-01
1 reads
I have a Database of size 200 MB and my transactio log is 13GB(very high).So can I truncate the log file by taking a fresh full backup?Thanks.
2004-09-16
2 reads
Hi Guys,If I've got pending transactions in transactional replication, is this going to block further replication.Also should I be getting pending transactions?I can see Pending under Status for the subscrption so I am assuming I have pending transactions.Anything I can do to troubleshoot this.ThanksGraeme
2004-09-14
1 reads
HiKalen Delaney in Inside SQL Server states that 'A separate RAID-10 array is usually not an appropriate choice for the transaction log. Because the write activity tends to be sequential and is synchronous, the benefits of multiple disks are not realised.'This seems logical to me but what if you have more than one database on […]
2004-08-12
50 reads
select columnx, count(*) from tableagroup by columnx is how you do aggregates.index_hints....spelling/punctuation might be wrong....but look in BOL for info...or search here for the keywords "with index, hint"scans....prevent by ensuring columns referenced are 'indexed'....an indexz defined on (cola,colb) in that order is no good to prevent a scan if your query is "select colb from tablea"...whereas it'll […]
2004-08-04
How did you reference the appended tables when you needed historical changed data? As far as the zip codes go, i was thinking of backwards compatibility on the application side. In other words, i was going to do a data drill down starting @ country first, then region, then state etc... until i got to […]
2004-07-22
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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