Data Mining Part 21: Excel and Data Mining,validation methods
This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.
Removing Rows with the DELETE Statement in SQL Server
Greg Larsen explores how to remove rows from a SQL Server table using the DELETE statement.
SQL Monitor Custom Metric: Possible Duplicate Indexes
When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.
Continuous Learning
It pays to continuously learn more about your job. SQL Server is so large, it really is a lifelong effort to drive yourself forward to master more and more.
Prepping for Winter
As winter approaches, many of us get ready in our personal lives, but Steve Jones notes that we might want to make sure we have regular preparation taking place on our systems for difficult times.
SQL Overview VII - SSRS Reports and Subscriptions
In the next installment of his series on the SQL Overview toolkit, David Bird looks at the information collected about SSRS.
SSIS 2012 Projects: Setup, Project Creation and Deployment
It used to be that SQL Server Integration Services (SSIS) packages had to be deployed individually. Now, they can be all deployed together from a single file by means of the Project Deployment Model introduced in SSIS 2012. Where there are tens or hundreds of SSIS packages to deploy, this system is essential.
Bucket List Data
This Friday Steve Jones is looking to see what data you're tracking about your life.
ETL Performance Auditing - Part 3: Auditing Data Warehouse Phase
Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
Blogs
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers