SQL Homework – May 2022 – Books on Line

Leave a comment

May 5, 2022 by Kenneth Fisher

No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of time looking things up. Frequently I’ll just do a web search, but, at least in the case of MS SQL Server, Books on Line is one of my top choices. It’s not always perfect, but it’s certainly a good place to start.

So here’s what I’d like you to do. Look up at least 10 of the following in BOL. Try to pick ones you don’t know, or at least don’t know well.

  • What are the permissions required for OpenQuery?
  • What command should you be using in new development instead of RAISERROR?
  • How many expressions can be included in the SELECT list?
  • Look at the example for the query hint MAXRECURSION.
  • Review the syntax for creating a login.
  • Is the text data type supported by the OUTPUT clause? Are there any restrictions if it is?
  • What is a generic term to return the identity column in the SELECT list?
  • What permissions are required to alter an ASYMMETRIC KEY?
  • What does DBCC OPENTRAN do?
  • Look at the example for using a CTE with an UPDATE.
  • What type of lock is taken on the table when running sp_estimate_data_compression_savings?
  • What is a DATABASE SCOPED CONFIGURATION?
  • What are the data types for the different outputs of sp_help?
  • When using COVERT to convert to a datetime data type what does the style 126 return?
  • When you run sp_updatestats what happens with disabled indexes?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,653 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: