So I think there's a value in testing someone on their scripting, and I don't see a way to avoid baking some degree of syntax awareness into that test. But if you don't know it exists, it's going to take you way longer to solve a "stuck transaction" problem than it will the guy who knows what he's looking for.Īnd the best way to know something exists and understand how to use it is to practice with it - which involves using it in a script. 327 394 Exercise 9.1 Exercise 10.1 Exercise 10.2 Scaling Out AdventureWorks. If you don't remember the parameters for sp_setsubscriptionxactseqno, that's probably good (because if you're using it often enough to remember, your publication has problems). select s.CustomerID ,p.FirstName +' '+p.LastName as Name from Sales.Customer s,Person.Person p where s.CustomerIDp.BusinessEntityID order by s.CustomerID select CustomerID ,count (SalesOrderID) as OrdersCount from Sales. I agree that googling what you don't know, especially syntax - I have to look up the syntax for case statements every time I use one - is an absolutely core skill for a DBA, but you at the very least have to know that something exists for you to google. I tried to write each select statement by itself (see below), but I'd like to be able to combine both queries into one. Heres a list of SQL Server Tutorials ( retired) for SQL Server 2008: Management Tutorials. BANK of SQL Questions Queries, all related to database. Let's be honest, though - if you're interviewing someone for a senior DBA position who has to look up the order of BY.HAVING every time, that's going to be a ding against them. Question 1 Using the AdventureWorks database you have access to, examine the Sales.SalesOrderHeader and Sales.SalesOrderDetail tables. Write a query that returns the Name, ProductID, Color, Size, ListPrice, and ReorderPoint from the Production.Product table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |