Virtual Chapters

Technical Article

Documenting SQL Server with PowerShell: PosH VC

  • Article

Virtual Chapter meeting, Mar 16, 12pm EST. Documentation is mostly overlooked and only comes up when a problem arises. What if you'd have a tool or method to generate documentation for all your database servers? In this session, Sander Stad will show you show how easy it is to use PowerShell to retrieve information from your servers. He'll detail what can be used to document your servers, how to retrieve the information and what should be documented. In the end you no longer have an excuse not to document your servers.

2016-03-15

4,054 reads

Technical Article

RE: re-index

  • Reply

Andy, According to the article at http://www.sql-server-performance.com/statistics.asp : "If the number of rows in a table are greater than 6, but less than or equal to 500, then statistics are automatically updated when there have been 500 modifications made. If the number of rows in the table are greater than 500, then updates are automatically […]

You rated this post out of 5. Change rating

2003-07-28

1 reads

Technical Article

RE: Identity Function Problem

  • Reply

Testing in SQL2000, it does not even allow a variable when used with the IDENTITY function. You could do something like this, however. exec ('select field1, IDENTITY(int,' + @val1 + ',1) AS [ID] into #temp_list from table2 select * from #temp_list order by [ID]')

You rated this post out of 5. Change rating

2003-07-23

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