(Derek E Wilson) Set operators allow you to combine data from two or more queries and return the results in a single set. There are 3 set operators available T-SQL EXCEPT, INTERSECT and UNION.
Tag: sql server
Get Ready to Learn SQL Server 21: Using Subqueries in the WHERE Clause
(Kris Wenzel) This is the third in a series of articles about subqueries. In this article we discuss subqueries in the WHERE clause. Other articles discuss their uses in other clauses.
SQL SERVER – How to Know Backup History of Current Database?
(Pinal Dave) Some blog post and scripts are like ever green references. One such blog has been Get Database Backup History for a Single Database. A number of you have pinged me and for amendments to that script with various ideas.
Tip # 4 – Not having a Baseline
(Chris Shaw) This article is part 4 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency.
The most recent backup problem
(Matt Bowler) When I first began this blog, back at the beginning of my DBA career, it was purely a place for me to keep queries, things I was learning, processes and handy links. This is one of those posts, there’s nothing new or ground-breaking here – just an elegant simple solution to a common pr
T-SQL – Query to get Distinct,Sorted, Comma Separated values in to a variable
(Prashanth Jayaram) There are many different ways to accomplish this tasks.
Questions About SQL Server Transaction Log You Were Too Shy To Ask
(Tony Davis) You can give a deep-dive presentation about SQL Server’s transaction log, and round it off by inviting questions. Your audience will stare awkwardly at their boots. Afterwards, to your surprise there will be a queue of questioners, and the questions are the ones they were too shy to ask
SQL SERVER – Error: Msg 701, Level 17, State 103. There is insufficient system memory in resource pool to run this query
(Pinal Dave) Talking and exploring In-Memory topics inside SQL Server 2014 has been interesting to me. When I wrote the blog around table variable not being just an In-Memory structure, one of my course listener (SQL Server 2014 Administration New Features) pinged me on twitter to ask, if In-Memory
Find SQL Server Agent Jobs That Exist on One Instance and Not on Another Instance
(Tim Smith) We have multiple SQL Servers across development, QA and production and we need to quickly determine what SQL Server Agent Jobs exist in one environment, but not the other. This will help us determine if these jobs are necessary, currently in development, or being tested in development b
How to Rebuild MSDB database?
(Rohit Garg) I suggest to have regular full backup of your system database along with user database. But if you do not have system database & your MSDB got corrupted then you have to rebuild it. You can do it by instmsdb.sql script comes with installation.