5
POPSWonderful comments from the new Clipmarks users WoW. I feel good being there among the others as well. CM Team, take a look at the comments on the slowness, I know you must have already :) The site rocks! Let's build some more media buzz, your hard work deserves it.
4
POPSMicrosoft's $528 Mil Tax Break Keep in mind these numbers are all estimates, and that Microsoft is definitely not the only company that does this sort of thing. But I figure that doesn't make it any less sleazy.
2
POPSPrimary Keys: IDs versus GUIDs I really am tempted to try it out sometime. I want it just to rid myself of the evil SEQUENCE crap in Oracle. I like the idea of generating the ID in my .NET code instead of having to retrieve it from Oracle via a second round trip. I hate Oracle. For SQL Server, well... inserting a record and getting it's new ID back via the IDENTITY column type is SO easy as to be a no-brainer. Unless you need it for replication or whatnot. Still, I'm tempted because I like to do things *one way* regardless of Oracle or SQL Server, but... /sigh
1
POPSSQL Server 2005 List all IDENTITY columns When I upgraded one of my databases to MSSQL2K5 compatibility mode, I noticed that many of my insert statements on tables with identity columns started generating primary key violations. I realized that I needed to run DBCC CHECKIDENT on all of those tables to fix the problem. I found this script, which lists all of the tables, in a database, that have identity columns. Then a copy/paste and regex search/replace generated a script for me to run the DBCC CHECKIDENT for each table listed. After running the DBCC CHECKIDENT, the problem went away.
1
POPSYou can use an external editor with sqlcmd I haven't really done much with SQL Server 2005. I'm getting myself in the situation where I must, though, as I am using it as the platform for capturing performance counter data. I let the database grow way out of pocket and am now suffering the consequences. I know back with SQL Server 2000 you could use the osql utility to run commands and scripts from the command line. Looks like you do the same thing using sqlcmd for SQL Server 2005. I'll probably be using this to execute a command file to shrink the transaciton log when it gets too big. I'll be using Performance Monitor's Alert feature to detect when the script needs to be run and have the action be to log a record in the application event log and to execute the script to truncate the log. The other alternative is to use SQL Server Agent to execute a cleanup script in a more meaningful manner. Consider my first suggestion a failsafe.
1
POPSAvoid Temp Tables I've been working on removing the use of temp tables in some of the procedures that I've inherited. I think it's helping with the database performance.
1
POPSEasy Way to Request Hotfix from Microsoft In case you are wondering, all the hotfixr site really does is submit a form that redirects you to this Microsoft page, replacing ID with the number that you put in. http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=ID But it still saves you an extra step, probably worth bookmarking if you do a lot of maintenance on Microsoft products.
1
POPSMSDE unsupported on MS Vista Is Microsoft planning to discontinue MSDE product and support? Or is it that presently due to the architecture differences MSDE isn't supported on MS Vista?
1
POPSSQL Server 2008 - Finally a DATE datatype? OMG this is my most wanted feature like EVER. It was promised but removed from SQL Server 2005. Will it really come this time? If so, I promise to convert all my apps to 2008 immediately upon release.
1
POPSfn_virtualfilestats Not exactly sure how this might help, but it's available... I found it in SQL Server Magazine's website and thought I'd clip it.
1
POPSDBCC DROPCLEANBUFFERS I saw one of my colleagues using this procedure. I haven't used it myself, but I think I'm about to start experimenting with it. I think the part about executing a CHECKPOINT first makes sense.
1
POPSDailyWTF: Very Slow Service It's not so astonishing to find something as klugish and ass backwards as this. What's humorous to me is how it all panned out.
1
POPSPassword Generator Great tool that will allow you to create totally random passwords, based on one master password. If you ever lose it, then just return to this form, stick in the master pass, the site name, and the password will be revealed!
1
POPSIndexes have their disadvantages I've seen a lot of people talk about the consumption of disk space with respect to indexes, but I don't remember seeing mention of how it could consume memory space. I believe that makes sense. And seeing how I'm fighting with memory right now, it makes me think twice about slapping yet another index on my tables.
Most Pops
see Most Pops
Clips
Pops
Comments
Tags
1
Print
Save
Turn on live update