Depending on your age, you may not want to know this number, but as you advance in your career, this might be a problem that you look to solve one day. Peter Larsson takes a few minutes to work out a function in T-SQL that can be used to solve this or any similar question.
Visual Studio developers have enjoyed the benefits of intellisense for some time, but us SQL Server users have had to work from memory. Wayne Fillis was so enthralled with a new offering from Red Gate he wrote a short review and sent it in. Check out his thoughts and how this product can help you.
This article describes the "beta" version of Simple-Talk's SQL formatting tool, SQL Prettifier. It provides links both to try it out online and to download the full source code (members only). Please give us your feedback! We will be offering prizes for any fixes and improvements that make it into "v1". I'd like this to become the de-facto (excuse the pun) tool for presenting code in the Simple-Talk articles, blogs and forums.
The second in a series from Adindam Banerjee on server performance and capacity planning. This time Arindam takes a look at the memory requirements for SQL Server.
SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work of copying the database in an automated and highly parallelized way.
This is an entry level look at how temp tables work in SQL along with some tips about how to use them effectively.
This is the second of a two-part article that explores the language features of SQL Full-text Search (SQL FTS), an component of SQL Server 7 and above that allows fast and efficient querying of large amounts of unstructured textual data. Part I dealt with index time language options, covering how words or tokens are broken from the text stream emitted from the iFilters and stored in the index.
Performance tuning often seems like it can be more of an art than a science. However there are a number of fundamentals that can help you tune most of the queries that you will write or have issues with their performance. Don Peterson brings us a look at how he tuned a query in the real world to avoid a conversion that can cause a query to run slower.
In Part I and Part II of this series, we saw how to install the SQL Server 2005 Data Service component. In this section of this series, I am going to illustrate how to install SQL Server 2005 Database Services and SQL Server Analysis Services on a host machine using an .ini file.
Reporting Services has proven itself to be an amazing platform on which to develop all types of reports. Author Asif Sayed brings us some .NET code for using Reporting Services to return data recursively in a report.
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers