SSIS At Christmas
Due to overwhelming demand, we've opened up another Integration Services class. Start Christmas vacation early in Orlando on Dec 18.
2006-08-28
2,158 reads
SQLServerCentral
Become an ETL Expert
Learn ETL solutions from SQL Server MVP Brian Knight at the SQLServerCentral.com training center.
2006-08-08
6,252 reads
Contract Work
Make a little extra money and find a contract job through our partnership with HohGigs.
2006-06-14
5,824 reads
PASS 2006 Reception
Once again the SQLServerCentral.com staff is putting on a Tuesday night reception. Read how you can attend this November in Seattle.
2006-06-13
1,874 reads
The May SQL Server Standard
Better late than never, here's a look at the May issue of the SQL Server Standard, now available as a PDF.
2006-06-07
4,107 reads
May SQL Server Standard
The May issue of the SQL Server Standard is out and we're printing as you read this. This month we take a look at the Ovation Research Group.
2006-05-04
2,737 reads
A Contest from APress
Apress, one of the premier techincal publishers, is releasing quite a few titles based on SQL Server 2005. They've agreed to sponsor our Question of the Day and give away some books. Read how you can win and what they're offering.
2006-05-01
2,445 reads
SQL Server 2005 Logon Triggers
One thing that many people tried to implement in SQL Server 2000 is the auditing of logins. However getting this to work was a complex process. In SQL Server 2005, however, there are a few ways you can handle this and new author Frederik Vandeputte brings us a method using Service Broker for handling this.
2006-04-17
25,480 reads
2006-04-11
2,977 reads
SQLServerCentral.com 5 Year Anniversary
It's been 5 years that this community has been live and Steve Jones takes a short look back at the community as well as announcing a few prizes.
2006-04-10
2,975 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
We Should Demand Better
Comments posted to this topic are about the item We Should Demand Better
Estimated Rows
Comments posted to this topic are about the item Estimated Rows
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch? See possible answers