This was a fun one, I couldn’t find a definitive answer on this so here is mine. Question How can I attach a database (MDF/LDF) to my […]
SQL Server 2008 R2 will not install – Unhandled Exception has occurred in your application.
Buggy Installers This is a fun installation problem it almost made me pull my hair out trying to figure it out. Concerning installations I honestly […]
Straight to the Point: Query for Database and Table Sizes
I love how I have to search too much to find simple information, one liners, it is just like in College where my college course […]
Query SQL Server using PowerShell
I don’t understand why it was so difficult for me to find an example on this, so I compiled one from three posts so I […]
Selecting Random Date Between a Date Range with tSQL
I had a very interesting experience recently trying to figure out how to select a random date between a date range using tSQL, it was […]
SQL Server: Tips on Declaring a Decimal Data Type
One of my pet peeves about SQL Server is the decimal data type. Declaring it once in a table where you don’t have to do […]
How to connect to a remote SQL Server
I posted about this on Stackoverflow.com http://stackoverflow.com/questions/2486610/how-to-connect-to-sql-server-from-another-computer/6765184#6765184 I think I will revisit this later to find the correct 1 way solution to this problem.
How to install sql server management studio 2008 component only
I posted an answer to this question on Stack Overflow here
UPDATE SELECT FROM JOIN
This is something that I don’t do often, but it pops up every now and again. I always forget how to do it, so I […]