microsoft sql
SQL201–The OUTPUT Clause
Starting with SQL 2005 SQL introduced a new clause for your INSERT, UPDATE, DELETE, and MERGE statements...the OUTPUT clause. If you're not using it yet, it
microsoft sql
sql
SQL 201-Table Variables
It's been a while since I've added to my SQL 201 series, so I thought I'd pick up with table variables. In an earlier post, I covered temp tables. Temp tables
sqlpass
Don’t Miss My Session at SQLSaturday #80
That's right! I'll be speaking at this weekend's SQL Saturday event in Wheeling, WV. I'm the last speaker in track #3. I'm looking forward to Ed Wilson's
microsoft sql
SQL 201-Ranking Functions
It's been a while since I've covered a SQL 201 topic! I want to jump back into it with ranking functions. These are functions that let you represent orders in
microsoft sql
Some Blogging Changes
Some Blogging Changes 2011 July 8 by Shannon Lowder You may have noticed there are fewer posts on here than there have been in several months. Well, I’ve been sitting on some news. I’m working with several new sites to publish articles. I’ve made the decision to make this site...
sql
70-432: Post-op
I passed the 70-432! After two months of preparations I did it! I'd like to let you know a little about my experience with SQL, so you can judge how much of
sql
Tips for SQL N00bs
Everyone in PASS and everyone following the #sqlhelp hashtag on twitter was a SQL n00b at one point. That includes me. So when I started compiling my SQL101
sql
Another Guest Blog
I’ve got another post up at WMW.com.br! This time I’m taking on CXPACKET waits and parallel queries. I also go into why setting MAXDOP to 1
sql
SQL 201-Non-Correlated Sub Queries
It's been a while since I've covered any material for my SQL 201 series, so I thought I'd jump back into it with non-correlated sub queries. It's a mouthful.
microsoft sql
70-432: A Closer Look at Agent Jobs
I was taking a practice test for the 70-432 when I got a question that covered a scenario I’d never even thought about before. It had to do with options
sql
70-432:Another Backup Scenario
I've covered the differences in the recovery options before. So you should be mostly prepared for the following scenario. It requires you being familiar with
sql
70-432: Execute as Owner
Another topic you'll need to understand in order to pass the 70-432 is how you can grant permissions to a user to accomplish a certain goal, without granting