The Scary DBA

Technical Article

RE: running snapshot agent immediately in tran rep

  • Reply

There is a check box when you add the subscription to start the snapshot immediately, really it just runs the job for you. In addition to the reply above. The start the snapshot immediately option only available when you check the 'Show advance option in this wizard' in the very beginning when you add subcription. […]

You rated this post out of 5. Change rating

2003-06-27

Technical Article

RE: filegroups and performance

  • Reply

Definitely NOT. I would recommend to create more files per each group and place on the different disks (2 to 3 file on each disk), this will definitely improve the performance because when reading the table a separate thread will be created for each file to access the table data. If your table is heavily […]

You rated this post out of 5. Change rating

2003-06-26

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