This blog is part of my series Making Data Tell a Story With SSRS Properties. Property: FixedRowHeaders The purpose of this property is to show row headers as you scroll across a page to view data. To access the property, select the tablix and select FixedRowHeaders. The options are True or False. Example: I have a matrix that displays order counts and totals by year, grouped by sales region. The Territory Name header appears when I am left-most in the rendered report.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
In my Differences between Oracle and SQL Server when working with NULL and blank values post I already showed you how blanks and NULLS are handled differently between Oracle and SQL Server. Today I found another interesting tidbit. I you have a varchar or char datatype in SQL Server and you store a blank, you get back a blank or padded spaces. DECLARE @Test1 varchar(10) = '' DECLARE @Test2 char(10) = '' SELECT @Test1,@Test2 The output is one blank and ten spaces.
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 SSMS. He tweeted the following link: Selecting Columns to Display in SSMS I decided to check it out. I knew already about the details pane, I use it all the time if I need to script more than one object.
A SQL Server Support Windows Phone App has been released in the Windows Phone App store. This app will work on Windows Phone 7, Windows Phone 7.5 as well as Windows Phone 8 Description from the site Get quick access to SQL Server and SQL Azure troubleshooting content from Microsoft SQL Server Support team blogs and recently published KBs. I already installed mine, you can get yours here: http://www.
Introduction I admit I had been neglecting ChocolateyGUI for the last year or so. And it was no longer compatible with the current version of Chocolatey. But a few weeks ago a gentle soul called Miracula decided it was time to help and I made her a contributor the moment she did. After all it was my very first pull request ever and I was happy. This weekend I decided to give ChocolateyGUI some more of my love and attention.
Sometimes you want to quickly see what tables have the most rows in your database. This is especially true 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. Just be aware of these remarks from Books On Line
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 databases. What if I want to get the list returned order by size descending? This is pretty easy if you dump the results into a table and then do the sorting when doing the SELECT query against this table.
This blog is part of my series Making Data Tell a Story With SSRS Properties. Property: FixedColumnHeaders The purpose of this property is to keep column headers visible as you scroll down a page to view data. To access the property, select the tablix and select FixedColumnHeaders. The options are True or False. Example: I have a matrix that display order counts and totals by year, grouped by sales region. The Year header appears when I am at the top of the rendered report.
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 When you drop or rebuild large indexes, or drop or truncate large tables, the Database Engine defers the actual page deallocations, and their associated locks, until after the transaction commits.
This blog is part of my series Making Data Tell a Story With SSRS Properties. Property: Interactive sort The purpose of this property is to allow you to add interactive sorting capabilities to a textbox in a table or matrix. This allows the user to toggle ascending or descending order for the rows. To access the property, go to Text Box Properties and select Interactive Sorting. The options are Enable interactive sorting on this textbox, Sort by, and Apply this sorting to all groups and regions.