SQL Server Index Properties in Management Studio
I'm creating an index in SQL Server using SSMS and I'm a little overwhelmed with all the index properties. In this tip we explain what each property is meant for and the options you should take.
Brady has been in the IT industry for 10+ years. He has worked in administrative roles using MSSQL 2000 to 2012 as well as Sharepoint 2007 and 2010. He currently serves as a Database Administrator in Nashville, TN. You can view his blog @ http://www.sqlbrady.com.
- MSSQLTips Awards: Trendsetter (25+ tips) - 2013
Downgrade from SQL Server Enterprise Edition to Standard Edition
I have a SQL Server that was installed as Enterprise Edition. I do not need the Enterprise features and I do not want to pay for the licensing. What is the best way to downgrade to Standard Edition? In this tip we walk through the steps.
SSIS Data Type Conversion Testing
I�ve been tasked with a project where I need to extract data from one source and load into a destination. I plan on using SQL Server Integration Services (SSIS) and that seems simple. The only caveat is that I need to modify some of data types during t
Removing Duplicates Rows with SSIS Sort Transformation
I have multiple duplicate records in my SQL Server database. I am using SSIS and I want to know what is a quick and easy way to remove. In this tip we look at how this can be done with the sort transformation.
Using the Deploy Database to SQL Azure Wizard in SQL Server Management Studio to move to the Cloud
Learn how to deploy a database to SQL Azure using the wizard in SSMS.
Fixing SQL Server error in-row data RSVD page count is incorrect
I ran DBCC CHECKDB (Integrity Checks) in my maintenance plan and I also ran it manually, but I keep getting the error “The In-row data RSVD page count for object “table_name” , index ID 0, partition ID 58037252456448, alloc unit ID 58037252456448 (type In
Move an On-Premises SQL Server Database to the SQL Azure Cloud
I’ve introduced my manager to SQL Server’s cloud based platform, SQL Azure and Windows Azure Virtual Machine. He wants to test functionality with some of our applications, which would require me to move my on premise databases to the Azure Virtual Machine
Identify and Correct SQL Server Forwarded Records
Forwarded records in SQL Server can cause performance issues on heap tables because the record outgrows the page and the database engine uses pointers to reference the data. For those that don’t know what a heap is, it is a table without a clustered index
Microsoft’s new 3D data visualization BI product – GeoFlow
Microsoft has introduced a new BI product that will provide 3D data visualization using Bing Maps. This product is still in beta and is codenamed “GeoFlow” but should be out late 2013 or early 2014. This preview will allow you to plot geographic and tempo
More Uses for Data Explorer for Excel
Microsoft has introduced a new BI product that will help simplify the data discovery phase for Excel users. “Data Explorer” is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and acces
SQL Server Simple and Forced Parameterization
I have heard about parameterization for SQL Server queries, but what is Forced and Simple Parameterization and which one should I use for my SQL Server database? In this tip we will take a look at these two options and what they mean.
Using the SSIS WMI Task to Gather System Information
When I need to find server information such as OS info, disk usage, memory allocation, etc. from SQL Server I can usually query DMV’s or system tables, however, what if I need to find server information where SQL Server is not installed and querying table
Building Key Performance Indicators (KPIs) with PowerPivot
While PowerPivot isn’t necessarily “new technology” I think businesses are trying to move towards it because Excel savvy end users can create their own reports without tying up IT resources. KPI’s are just another addition to PowerPivot that allows users
Detect SQL Server CPU Pressure
I’m trying to tune my SQL Server and I’m having a hard time deciding if my CPU is under a lot of stress. What’s a quick and easy way to detect CPU pressure? Check out this tip to learn more.
PowerPivot with Excel 2013
I have read all the tips regarding PowerPivot using SQL Server as a data source, but I’ve started using Excel 2013 and need some help making a nice, simple dashboard for a presentation coming up. In this tip we show how you can format PowerPivot.
SQL Server Partition Wizard
SQL Server Partitioning can be a bit confusing and can lead some companies in a different direction as far as archiving data. Writing the T-SQL code to create partition functions, partition schemes, and then altering the table to use the partition can be
Restore SQL Server Databases using DateTime functions
I have to restore a production database to a development database on a weekly basis in order to refresh the environment. Currently, I’m doing this process manually. Is there any way to script this out so it can be automated? Check out this tip to learn m
How to create and use Temp tables in SSIS
I'm trying to use a temp table in an SSIS package. It seems like everything is working correctly until I try to query the temp table. What am I doing wrong?
Report to Capture Table Growth Statistics for SQL Server
I would like to monitor table size growth and build a report that will help me monitor table growth. Is there any way I can automate this without buying a third party tool? In this tip we look at using T-SQL and SSRS to accomplish this.
Understanding Column Properties for a SQL Server Table
I'm creating a table in SQL Server using SSMS and I'm a little overwhelmed with all of the column properties. In this tip we explain what each property is meant for and the options.
Managing SQL Server Extended Events in Management Studio
We’ve all heard about Extended Events and how they can help troubleshoot SQL Server performance, connectivity, and locking problems, but they seem so difficult to implement using T-SQL. Isn’t there a better way to implement SQL Server Extended Events?
SQL Server User Defined Server Roles
Ever get tired of assigning server level permissions by adding a login to a predefined server fixed role and then assigning multiple permissions to that login? In SQL Server 2012 you now have the ability to create a User Defined Server Level Role.
SQL Server Clustering Management inside the command line
Experienced SQL DBA’s know their way around Failover Cluster Manager fairly well. The graphical tool is a great, but what kind of management tasks can I do when my Failover Cluster Manager freezes or something prevents me from starting the program? In th
Apply a Service Pack or Patch to Mirrored SQL Server Databases
I'm planning on patching my SQL Servers to the latest service pack, but I’m not sure how to complete this for a environment that is using database mirroring. In this tip we cover the steps.