Browse by Tags
All Tags »
SQL (RSS)
Sorry, but there are no more tags available to filter with.
Dave Strommer first brought Multi-Tenant Data Architecture MSDN Article to my attention a few months ago. Unfortunately, I've had this article in my items to review folder. Anyway, I finally read the article in detail and thought it quite valuable...
Found this query on MSDN SQL Blog and tweaked it a bit. It shows index info including the space used by each index....
This Simple query was created from a demo Microsoft Smart Client Application called IssueVision. To create it I right clicked on IssueHistory table in SQL Server Management Studio 2005. Notice the commas are all to the left of the column names....
How do you name your SQL Tables? Are the names singular or plural? A friend suggested that tables should be singular because they represent a single record instance of data stored in the table. When multiple records are selected then a collection is created....
There are many great topics of debate in software development. DataSets Vs. Objects, Smart Clients Vs. Web Apps, and Stored Procs Vs. Dynamic SQL. Many have argued that writing stored procedures is rigid and doesn't allow for an easy way to build detailed where clauses. Furthermore, SQL Server 2000 caches execution plans so in theory SQL Statements should be optimized if used often. Finally, .NET allows for parameterized queries helping to protect dynamic queries from SQL Interjection. ...