New and Basic Result-set Paging functionality in SQL 2012 Version.
Overview of 2 very important clauses added to SELECT statement in SQL2012 to allow paging on result sets.
2013-04-10
640 reads
Eli Leiba
Methods For Converting a Stored Procedure
An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.
2011-04-08 (first published: 2009-10-29)
34,855 reads
Generating Permutations in T-SQL
In testing your applications, one of the things that you often want to do is run through a list of all possible values for some particular piece of code. Eli Leiba brings us a method for autmatically generating all the possible permutations for input values.
2005-10-19
20,199 reads
Tokenizing a String Using PARSENAME
SQL Server string manipulation using T-SQL leaves lots to be desired. Many postings and complaints about T-SQL deal with strings, but there are ways to work with it. Author Eli Leiba brings us a way to split out portions of a string that contains tokens with a user defined function. Read on to see how this is accomplished and the code used to perform the splitting.
2004-12-27
11,823 reads
Evaluating Boolean expressions using T-SQL
Every once in awhile there is a unique T-SQL solution in SQL Server that solves a rare problem. Not many of us have had to deal with boolean evaluation in our jobs, but a few have. Author Eli Leiba has and brings us a new article that shows how to build a procedure that can take a boolean expression and evaluate it to true or false.
2004-12-21
14,906 reads
Tracking Down Newly Created Databases
SQL Server was designed to make the DBA job easier, distribution of security, automated procedures, etc. But in some areas it either does not go far enough, or a feature is used for an unintended purpose. One of those areas comes into play when allowing many people to create databases. Author Eli Leiba brings us a tecehnique he uses to close the gap and track down those newly created databases.
2004-11-18
4,916 reads
Identifying Blocking Locks
Blocks in SQL Server can cause untold amounts of pain and headache, mostly because they are so transient and often when you go to look for them, they have been released on whatever object you are researching. Author Eli Leiba has writeen a short piece on how you can automate the search for blocking locks and help you as a DBA be proactive in identifying them.
2004-10-28
12,388 reads
Implementing a Flexible Backup Strategy
SQL Server has a rock solid backup routine that works every time. However the schemes used to implement backups with maintenance plans, Enterprise Manager, etc., are not a smooth or as flexible as what most people require. Author Eli Lieba brings us his strategy and code for ensuring that each database is backed up how he needs it to be, whether a full or differential backup.
2004-10-19
11,315 reads
Handling Simple XML Using T-SQL
SQL Server 2000 integrates a number of features to work with XML data and SQL Server 2005 should expand upon that. However the SQL Server 2000 extensions for working with XML data in T-SQL are not that mature. New author Eli Leiba looks at how he can traverse an XML file using T-SQL code.
2004-09-20
13,001 reads
Blogs
Building a Docker image with Docker Build Cloud
In a previous blog post we went through how to build a Docker container...
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Going to Cloud? Look at the Shared Responsibility Model
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
Forums
SQL server native CDC
Have anyone implemented CDC, and if so, what has been your experience with it?...
Import and Export wizard stuck on Guest user
I'm getting a error when using the Import and Export wizard to copy tables...
Aligning Compatibility Version Strategy
I have joined a new project, where the business uses Azure SQL Hyperscale for...
Question of the Day
Initial Config of tempdb
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers