Browsed by
Tag: SQL 2008

24 Hours of PASS…again!

24 Hours of PASS…again!

To some it may seem like I post about 24 hours of @PASS regularly, but is it a bad thing? Free web-based SQL information and training from industry professionals? You won’t hear me complaining! This set seems like it’s a little better than before, the link to the event is here. The sessions I will be attending are: WHY DATA WAREHOUSING PROJECTS FAIL (AND WHAT YOU CAN DO ABOUT IT). IDENTIFYING COSTLY QUERIES SQLBI METHODOLOGY T-SQL BRUSH-UP: THE BEST THINGS…

Read More Read More

Long SQL query time and account permissions

Long SQL query time and account permissions

My good friend @MichaelPerillo and I were recently discussing the possible cause for a SQL query to take an excessively long time, even though proper measures had been taken to ensure performance tuning had taken place. He made a suggestion that I believe is noteworthy, so I’m putting it here, also so I can reference it later. A transactional SQL database performs each transaction in a queue, assigning each transaction a queue request. Queue requests are prioritized not only by…

Read More Read More

Returning the Nth weekday in SQL…and in InfoPath

Returning the Nth weekday in SQL…and in InfoPath

Ok, after much research I found a forum that had a posting that demonstrated how to get the Nth chosen weekday of a month using T-SQL. Here’s the code: DECLARE @date datetimeDECLARE @weekday intDECLARE @day datetimeDECLARE @number intDECLARE @WhichOne int SELECT @WhichOne = 2 — Set this to the week you want to grabSELECT @number = 1SELECT @weekday = 0SELECT @date = getDate() — Change to dateadd(month, 1, getDate()) for next month, etc. WHILE @weekday 4 — Change this value…

Read More Read More

New code library site

New code library site

I created a basic code library site to host all of the code snippets I’ve gathered and/or created over time. Go here to visit the site. It’s pretty basic and empty right now, I’ll dress it up a little more as time goes on. I’m also trying to determine a better way of sub-categorizing the code in each of the language tabs. I welcome suggestions. Enjoy!

Problems installing SQL 2008

Problems installing SQL 2008

I had originally installed SQL 2005 Express on my laptop, and something happened during the installation and it got corrupted. I was unable to uninstall, whether I used Add/Remove programs, ran setup.exe ACTION=uninstall from the command line while in the SQL root path, even if I used msicuu2 and msizap to look for the GUIDs associated with SQL 2005. Nothing worked. I thought installing SQL 2008 Express might “fix” or overwrite something and then get me the latest version to…

Read More Read More