Early December 2010 Free Training from PASS Virtual Chapters
The Performance, DBA, and B/I Virtual Chapters of PASS are back with free training.
2010-12-07
970 reads
Free Training
End of October Free Training from PASS Virtual Chapters
This wraps up the last of the free training the PASS Virtual Chapters are providing in October.
2010-10-25
892 reads
Mid October Free Training from PASS Virtual Chapters
More free training this month from PASS B/I, PowerShell, and Oracle Virtual Chapters.
2010-10-20
704 reads
Late September Free Training from PASS VCs
The DBA and Virtualization Virtual Chapters hope that last weeks 24 Hours of PASS got you in the mood for more free training. Here's what they have on tap for you this week:
2010-09-21
712 reads
RE: Password problem in Enterprise Manager
I do not know of any limitations but apparently the problem does exist ... Here's a link I googled ... http://archives.devshed.com/a/ng/373-78/Password-Length-Issue-With-SQL-Server-2000
2005-03-02
RE: re-index
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 […]
2003-07-28
1 reads
RE: Insert statement latency
anam: good catch. don't know why I didn't notice that. You may want to contribute this little headache to the FAQ...just a suggestion. It may keep someone else from the same mistake!
2003-07-24
1 reads
RE: Converting hex to int
Hi Frank, In Master. I'm on SQL7 SP4 may be it has been dropped in later versions!
2003-07-24
RE: Identity Function Problem
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]')
2003-07-23
RE: Recursive instead-of-delete triggers
The example can trace 'American family back to the Revolutionary War'. Quote from the article. Done the lineage stuff in 6.5 but the lineage storage (varchar(255)) was a problem because of the key sizes used for the parent/children relationship. With SQL 2000, 8000 characters one should be fairly safe. Lastly, I am a big fan […]
2003-07-21
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers