Archive

BLOG SITEMAP:
Posts (61)  
   1.  SQL XML Bulk Load and Namespaces
   2.  COUNT on LEFT JOIN
   3.  The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns
   4.  Migrating to wordpress
   5.  @@rowcount and print
   6.  The MERGE syntax – syntax and performance
   7.  A STR issue
   8.  Changing domain
   9.  SQL XML Bulk Load – more XSD syntax
   10.  SQL XML Bulk Load, Relationships and composite keys
   11.  The OUTPUT clause
   12.  Upgrading to new engine
   13.  SQL XML Bulk Load and line breaks
   14.  Aggregated functions and CASE
   15.  Selecting latest order
   16.  SQL XML Bulk Load – some common errors
   17.  The IsNumeric Trap
   18.  Enabling moderated comments due to spam
   19.  Local variables and batch scope
   20.  SQL XML Bulk Load – basic XSD syntax
   21.  Sorting integers in a string using XQuery
   22.  SQL XML Bulk Load – introduction
   23.  Using INNER JOIN/SELF JOIN to allow for smaller indexes.
   24.  Rollback the transaction
   25.  Transaction and connection
   26.  Dynamic inequality checks
   27.  Filter parameters in a Stored Procedure
   28.  Using @@IDENTITY and SCOPE_IDENTITY()
   29.  Drop User: The database principal owns a schema in the database, and cannot be dropped
   30.  Select/Edit rows and Saving Changes is not permitted.
   31.  Assign orphan users to a new login
   32.  Cleaning a DateTime for the time portion/Converting DateTime.
   33.  LEN()
   34.  LIKE wildcards
   35.  Difference in assignment using SELECT and SET
   36.  An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON.
   37.  Linked Servers in SQL Server 2005
   38.  Bringing a database out of Restoring state in SQL Server 2005
   39.  UPDATE/INSERT syntax trick
   40.  UNPIVOT and CASE to solve a problem to find the highest column in a row
   41.  Using RANK() and CTE
   42.  Assign EXECUTE on all Stored Procedures
   43.  INTERSECT/EXCEPT versus IN/NOT IN
   44.  NOT IN versus LEFT JOIN
   45.  SQL Injection attack still going strong.
   46.  IN versus INNER JOIN
   47.  Partition removed by adding index
   48.  Delete using join-queries
   49.  SELECT COUNT Behaviour
   50.  More table partitioning and numbers
   51.  Table partitioning and some numbers.
   52.  The SELECT 1 vs. SELECT * in EXISTS conondrum
   53.  DateTime and Indexes.
   54.  Learning about execution plans. (part 2)
   55.  Learning about execution plans. (part 1)
   56.  Learning about execution plans. (intro)
   57.  Dynamic ASC and DESC and Order by DateTime
   58.  Kill active connections to the database
   59.  SQL: Watch those join clauses
   60.  SQL Fun: JOIN’s
   61.  SQL Oddity

Page 1