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.
.net android asp.net asp.net mvc azure backup bigdata book business intelligence c# community continuous delivery database denali excel gotcha how to indexing java mongodb mvc music store nancy nhibernate nosql performance powershell security silverlight 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 structuremap syndicated t-sql teamcity tip unit testing vb.net visual studio 2010 windows 7
- SQLDenis (597)
- Christiaan Baes (chrissie1) (545)
- Ted Krueger (onpnt) (347)
- Jes Schultz Borland (grrlgeek) (148)
- Eli Weinstock-Herman (tarwn) (130)
- Alex Ullrich (52)
- George Mastros (gmmastros) (46)
- Koen Verbeeck (45)
- Naomi Nosonovsky (27)
- Axel Achten (axel8s) (27)
- David Forck (thirster42) (22)
- chopstik (20)
- Kevin Conan (18)
- Rob Earl (14)
- thatrickguy (12)
Sometimes you want to quickly see how many files a database has, how much space a file is using and how much space is free. You can use the sysfiles/sys.files views or compatible views for that. From SQL Server 2005 onward you can also use the sys.datab…
One of the good things about working in technology is that you always will discover new things. The other day I created a blog post: Listing all your SQL Server databases ordered by size. Buck Woody replied to me on twitter that this is also built into…
Sometimes you want to quickly see what tables have the most rows in your database. This is especially rue if you inherited a new database and you want to know some stats about this database. Instead of doing a count(*) against every table, I usually just use the sp_spaceused stored procedure. this will run many times faster, usually it is instantaneous.
To see all the databases with their size on an instance, you can use sp_helpdb. That works but returns the results in some random order. In my case I see master, model and msdb followed by a couple of user database, then tempdb and then again some user…
Sometimes you want to quickly see what the biggest tables are in your database. Maybe someone just gave you a brand new database and you want to see which tables take up the most space. I usually use the sp_spaceused stored procedure, it runs quickly and gives me the data that I need. Just be aware of these remarks
SQLCop detects the following issues right now. What else would you like to see? Detected issues Code Procedures with SP_ VarChar Size Problems Decimal Size Problem Undocumented Procedures P…
Approximately a year and a half ago, friends of mine and I created SQLCop. Our motivation was to provide a tool that users can download and run against their database. This tool is very effective at detecting common problems with database configuratio…
I added an sqlcop package to the chocolatey repository.
SQLCop uses an internet connection to ensure that all checks and updates that are added are maintained. When SQLCop first loads, it checks the SQLCopConfig.xml file to determine if a new SQLCop.xml file needs to be downloaded. If SQLCop is unable to download the configuration file, it will automatically use the previously saved sqlcop.xml file. Because of this, a remote file request is always performed when you start up SQLCop.In order to work around this problem with proxy servers there is one of two things you can do to run SQLCop.
As I was working on a database yesterday I came across a curious sight, multiple columns defined as numeric(7,0), numeric(9,0), and so on. It seemed like someone was trying to provide the database with the most specific definition possible for a number of different pieces of data. Having never run into this particular practice, I immediately started searching for a reason. Was it smaller? faster? better?
:: Next >>