data security

Technical Article

RE: replication type advice

  • Reply

Daniel,Merge replication is designed to do most of what you need but from application stand point you just have to be carefull to perform primary key partitioning if at all possible On the other end conflict resolution can be performed through a custom stored procedure so that you can do what you please with it […]

2005-04-22

Technical Article

RE: SQL 2000 Runtime

  • Reply

Not sure what you mean by "runtime version" or "product version", but Reporting Services can be obtained from Microsoft and is 'free' to use with an existing SQL Server license. See this FAQ for more info: http://www.microsoft.com/sql/reporting/howtobuy/faq.asp

2005-04-13

Technical Article

RE: EMPTYFILE not working the 2nd time

  • Reply

Are you shrinking a data file or transaction log file?  If there are active transactions, it can't shrink beyond those.  Also, a transaction log is made up of multiple virtual log files.  It can't shrink to a smaller size than one of those.   If its a log file, you may need to run a process […]

2005-04-08

Technical Article

RE: How Can I Select All But One Record?

  • Reply

Hi Wayne,Its pretty late over here so I haven't had a chance to test for total accuracy but after running your code it seems to work really well ! However, what surprised me is that the update "removed" all the duplicates except one pair. I had to run the code again to get rid of […]

You rated this post out of 5. Change rating

2005-02-08

Blogs

Simple Talks Episode 7

By

The season 1, seventh episode of Simple Talks is out. Check it out, with...

A New Word: the McFly effect

By

the McFly Effect – n. the phenomenon of observing your parents interact with people...

Key mappings in Visual Studio Code

By

At a recent conference I was asked how I executed code during my presentation....

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers