Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
backup bigdata book business intelligence database denali functions gotcha how to howto indexing mongodb nosql performance sql sql advent 2012 sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sql server 2012 sql server denali ssis ssms ssrs syndicated t-sql tip
- SQLDenis (410)
- Ted Krueger (onpnt) (252)
- Jes Schultz Borland (grrlgeek) (102)
- George Mastros (gmmastros) (40)
- Koen Verbeeck (30)
- Naomi Nosonovsky (23)
- David Forck (thirster42) (20)
- Axel Achten (axel8s) (16)
- Kevin Conan (15)
- Eli Weinstock-Herman (tarwn) (13)
- Christiaan Baes (chrissie1) (12)
- sqlarcher (10)
- emtucifor (7)
- ptheriault (6)
- ktessereau (6)
Archives for: December 2008
Here we are with another fascinating episode of the SQL Friday, The Best SQL Server Links Of The Past Week show
Obviously this week is another slow week, here is what I found interesting this past week in SQL Land:
Using SQLIOSim to Diagnose SQL Server Reported Checksum (Error 824/823) Failures
Another good post by the PSS SQL Server Engineers
There is code available to take advantage of the sp_replwritetovarbin heap overflow bug
In a default configuration, the sp_replwritetovarbin stored procedure is accessible by anyone. To disable this proc you can run this as an admin on the box
Before disabling this pro read BradC's comment so that you do not break replication
Calculating Median and Mode with SQL Server can be frustrating for some developers, but it doesn't have to be. Often times, inexperienced developers will attempt to write this with procedural programming practices, but set based methods do exist. Be…
Here we go with the links for week 3
A common mistake DBAs make is overlooking the need to maintain the indexes that ship with system databases. Fragmentation is a concern on user databases but also is something that must be maintained on databases like ReportServer for SSRS.
I’m going to focus on SSRS as an example but keep this open to all of the systems databases you have on your instances.
Most successful reporting services implementations come with daily report generations, changes and high execution rates. That means the tables in the ReportServer database will change along with your reports. ...
:: Next >>