-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Barbarian

After working in the mortgage industry for 7 years, I transitioned into Business Intelligence and began learning SQL and .NET. My goal is to integrate my business knowledge into my development to intelligently analyze and find solutions to problems. Blogging offers me an option to share what I've learned as well as receive feedback on better practices and solutions.

Archives: April 2015

Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace...

I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of columns and a view name, and it would generate a select statement from this view. Due to requirements at the time, I needed the flexibility of the "MAIN" proc which… Read more

0 comments, 1,233 reads

Posted in SQL Barbarian on 30 April 2015

Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace…

I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of columns and a view name, and it would generate a select statement from this view. Due to requirements at the time, I needed the flexibility of the “MAIN” proc which… Read more

0 comments, 518 reads

Posted in SQL Barbarian on 30 April 2015

Restoring a database that doesn't exist

When restoring a database that doesn't exist, say for instance when a client sends a database to you, you can't use the option to restore database, because there is no database matching to restore. To get around this you need to use the Restore Files and Filegroups option and then… Read more

0 comments, 646 reads

Posted in SQL Barbarian on 28 April 2015

Restoring a database that doesn’t exist

When restoring a database that doesn’t exist, say for instance when a client sends a database to you, you can’t use the option to restore database, because there is no database matching to restore. To get around this you need to use the Restore Files and Filegroups option and then… Read more

0 comments, 178 reads

Posted in SQL Barbarian on 28 April 2015

SQL Sentry Pro Explorer is worth it...

UPDATE: 2015-04-28 15:49
- I created a few autohotkey scripts and solved the problem of collapsing panes and a few other annoyances. This has improved my experince a little. - Also noted one major improvement that would help with tuning is aggregating the total IO, and stats, rather than only… Read more

0 comments, 566 reads

Posted in SQL Barbarian on 22 April 2015

SQL Sentry Pro Explorer is worth it…

UPDATE: 2015-04-28 15:49 – I created a few autohotkey scripts and solved the problem of collapsing panes and a few other annoyances. This has improved my experince a little. – Also noted one major improvement that would help with tuning is aggregating the total IO, and stats, rather than only… Read more

0 comments, 187 reads

Posted in SQL Barbarian on 22 April 2015