It's a summer Friday, at least in the US and the northern part of the planet. It's also a holiday in the US, and I hope my fellow citizens remember the significance of today and read one of our founding documents.
I'm away on sabbatical, and I'm assuming that things are going great. I'm actually writing this in advance and scheduling it, but I'll likely be working just as hard, trying to improve myself in a few ways. I don't have the exact plans, but perhaps I'm working on a project, volunteering, in school, something else, or all of the above.
In any case, this is a slow day in the US, and at SQLServerCentral as we repeat a number of previously published articles. We re-use this content because we've found ove the years that people are busy. They're busy with their careers, and busy in their lives, and many of them miss any number of newsletters and pieces we've released. Re-running them allows people to see something they might have missed, or perhaps review a popular piece they have forgotten about.
I'd encourage you today, if you are working, to take a few minutes and browse one of the articles, perhaps trying to follow along in the code or even solve the problem without looking at how the author does. Brush up on some skills and be better prepared for some future assignment.
SQL Server Execution Plans shows you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defined in your query. How aggregations in GROUP BY queries are put together. Grab your copy today from Amazon!
Yesterday's Question of the Day
(by Abbas Kapasi):
How many rows will be returned by each SELECT statement?
CREATE TABLE A (col1 tinyint); CREATE TABLE B (col1 tinyint);
INSERT INTO A VALUES(1) ,(1),(1) INSERT INTO B VALUES(1) ,(1)
SELECT * FROM A CROSS JOIN B --1 SELECT * FROM A INNER JOIN B ON a.col1=b.col1 --2 SELECT * FROM A LEFT OUTER JOIN B ON a.col1=b.col1 --3 SELECT * FROM A RIGHT OUTER JOIN B ON a.col1=b.col1 --4 SELECT * FROM A FULL OUTER JOIN B ON a.col1=b.col1 --5
The values in col1 in both the tables is matched against each other resulting in 6 rows for all the SELECT statements.
Exit Code 1073741571
- I have an SSIS process that is misbehaving. Here is the edited error code:
[quote]Selected row details:
Date 7/3/2014 1:39:49 PM
Log Job History (XXXXXXX_Daily_Files_Import)
--drop table #temp
create table #temp (id int, idvalue int)
insert into #temp(id,idvalue)
Need help with employee hierrarchy
I need help with the following query:
declare @LoginId nvarchar(20)
declare @LoginName nvarchar(100)
set @LoginName=(select [FirstName] + ISNULL(''+[MiddleName],'') + ISNULL(''+[LastName],'')
from [dbo].[Employee] where EmpId=@LoginId)
APR Calculation NEEDED.
- I was hoping someone could help me with doing an APR calculation in SQL. I have Loan Amount, # of months(term),...
- Hello, I just encountered a strange result using the ISNUMERIC function...specifically something like SELECT ISNUMERIC('9990D7') or SELECT ISNUMERIC('9D7'). These statements return a...
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.