administration

Technical Article

Interschema Commonality

  • Topic

Hi all We have three core applications (2 others out of our control).. all in seperate databases and share some commonality as far as using similar data sets and more importantly, share keys, ie. pkey of one table in app A and other pkey in appB will form an intersection table between the two applications. […]

2001-07-15

2 reads

Technical Article

@@ROWCOUNT problem

  • Topic

Hi all Developers are calling @@ROWCOUNT after their queries to give them a total count of rows returned. They use this in the front-end screen to tell the users the total rows return whilst they are paging throw the result set. They are finding issues with @@ROWCOUNT which returns zero for various queries based on […]

2001-07-11

162 reads

Technical Article

backup software or methods

  • Topic

I was just wondering what other people are using for a backup solution. I have worked with legato, veritas datacenter, and arcserve2000. I don't use any of them anymore to backup databases directly. I use sql backup to dump the files to disk then use the backup software to move them to tape. I was […]

You rated this post out of 5. Change rating

2001-07-06

7 reads

Blogs

Deleting Old Local Git Branches–#SQLNewBlogger

By

I had a lot of local branches for a repo (actually a few repos)....

Use Your Voice

By

If you want more of a career and less of a job, one thing...

Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox

By

Are you ready to take your SQL skills from theoretical to tactical? If you've...

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