sqlzen.com

sqlzen.blogspot.com

SQLZen: July 2013

http://sqlzen.blogspot.com/2013_07_01_archive.html

Find Stored Procedures and Functions That Reference Certain Tables. Just replace the "search term" in the code snippet with the name of the table/view/stored procedure/function etc that you want to search on. On c search.id = o.[object id]. On c display.id = o.[object id]. Otype desc not in ('INTERNAL TABLE','SERVICE QUEUE','SYSTEM TABLE'). C search.[text] like '%search term%'. Posted by h.a! Links to this post. Delete All Database User Accounts for a Given Server Login. Do you use the GUI in SSMS? Datab...

sqlzen.blogspot.com

SQLZen: May 2012

http://sqlzen.blogspot.com/2012_05_01_archive.html

Why Its Good To Be Wrong. Most people don't like to be proven wrong. It seems like a basic instinct: we want to be right all the time. Being wrong is a sign of weakness, and we may be looked down upon by our peers for that weakness. Even when there are no peers involved and the realization of being wrong dawns upon us by way of self discovery, we admonish ourselves. So, have you been wrong today? Posted by Hakim Ali. Links to this post. Defrag All Indexes On a Database. If (@Database Name = ' ). Set @Err...

sqlzen.blogspot.com

SQLZen: November 2012

http://sqlzen.blogspot.com/2012_11_01_archive.html

Can a Table Really Have a Clustered Index? Say you have a table that looks like this:. Adding a clustered index physically re-orders the records on disk. Let's say we add a clustered index on the Employee ID field (there already are many articles on which fields to pick as clustered indexes, so I won't revisit that here). This would cause the rows to be ordered thus on disk:. 1 Find the name in the nonclustered index. 3 Return the record from the clustered index. Posted by h.a! Links to this post. In a p...

sqlzen.blogspot.com

SQLZen: A Complex Database Project in Visual Studio SSDT

http://sqlzen.blogspot.com/2015/04/complex-ssdt-project.html

A Complex Database Project in Visual Studio SSDT. This article describes one approach to creating a complex database project in Visual Studio with SQL Server Data Tools (SSDT). This was for a group of databases that had defied more than one previous attempt at being successfully converted into working SSDT database project(s) by senior DBAs and developers proficient in their craft. Let's take a closer look at just two databases in our layout: DB1 and DB2. The relationship between them looks like this:.

sqlzen.blogspot.com

SQLZen: April 2015

http://sqlzen.blogspot.com/2015_04_01_archive.html

A Complex Database Project in Visual Studio SSDT. This article describes one approach to creating a complex database project in Visual Studio with SQL Server Data Tools (SSDT). This was for a group of databases that had defied more than one previous attempt at being successfully converted into working SSDT database project(s) by senior DBAs and developers proficient in their craft. Let's take a closer look at just two databases in our layout: DB1 and DB2. The relationship between them looks like this:.

sqlzen.blogspot.com

SQLZen: Tables and Clustered Indexes Part 2

http://sqlzen.blogspot.com/2013/07/tables-and-clustered-indexes-part-2.html

Tables and Clustered Indexes Part 2. A little while ago I wrote a piece. On why a table does not so much have. A clustered index as a table is. A clustered index*. Here's a follow up with some SQL code that further strengthens that assertion, at least the way it is implemented in SQL Server. Let's start by creating a very simple table and inserting one record into it:. Create table dbo.test (id int). Insert into dbo.test (id) select 1. Select * from dbo.test. Here is the execution plan for this select:.

sqlzen.blogspot.com

SQLZen: Can a Table Really Have a Clustered Index?

http://sqlzen.blogspot.com/2012/11/db-concepts-101-table-cannot-have.html

Can a Table Really Have a Clustered Index? Say you have a table that looks like this:. Adding a clustered index physically re-orders the records on disk. Let's say we add a clustered index on the Employee ID field (there already are many articles on which fields to pick as clustered indexes, so I won't revisit that here). This would cause the rows to be ordered thus on disk:. 1 Find the name in the nonclustered index. 3 Return the record from the clustered index. Posted by h.a! In a previous life, I used...

sqlzen.blogspot.com

SQLZen: January 2013

http://sqlzen.blogspot.com/2013_01_01_archive.html

Universal Product Codes: a Database Primer. As a database primer, the intention of this article is to provide an introduction to Universal Product Codes, and their usage in a relational database. A real example of a UPC-A code is 043000014240, which belongs to the cereal Honey Bunches of Oats, made by the company Post. Here, the manufacturer code is 43000, the product family code is 014, and the product code is 24. The barcode representations of the UPC-A and the EAN respectively look like this:. The cod...

sqlzen.blogspot.com

SQLZen: August 2012

http://sqlzen.blogspot.com/2012_08_01_archive.html

The Value of Writing. I recently came across some very nicely written (! Pieces on writing, and am reproducing them below because they are worth reading and spreading the word about. Admittedly, these are self-serving, but they are good nonetheless. These are all taken from the book 'Getting Real' by 37 Signals (you can download it here. I highly recommend it to anybody developing software or managing software development). Getting Real by 37 Signals. Good writing skills are an indicator of an organized ...

sqlzen.blogspot.com

SQLZen: Find Stored Procedures and Functions That Reference Certain Tables

http://sqlzen.blogspot.com/2013/07/find-procedures-that-use-tables.html

Find Stored Procedures and Functions That Reference Certain Tables. Just replace the "search term" in the code snippet with the name of the table/view/stored procedure/function etc that you want to search on. On c search.id = o.[object id]. On c display.id = o.[object id]. Otype desc not in ('INTERNAL TABLE','SERVICE QUEUE','SYSTEM TABLE'). C search.[text] like '%search term%'. Posted by h.a! Subscribe to: Post Comments (Atom). Database as a Service. Live Like a DBA. Tables and Clustered Indexes Part 2.