SQL Lunch - Building a Performance Point Dashboard
Don't forget to attend the SQLLunch tomorrow.
#35-Building your first PerformancePoint Dashboard in SharePoint 2010
Speaker:...
2011-01-18
1,228 reads
Getting Fast Counts of Large Service Broker Queues
This question regarding getting a fast count from a service broker queue came...
2011-01-18
2,184 reads
Recap So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using PowerShell variables, what cmdlets and functions are, what...
2011-01-18
26 reads
Recap
So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using...
2011-01-18
1,373 reads
Microsoft has released new cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. Remember, both of...
2011-01-18
706 reads
January’s OPASS meeting will be held this Thursday, January 20th at 6pm. We will be meeting at the Hampton Inn, 850 Village Oak Lane, Lake Mary. SQL Server...
2011-01-18
8 reads
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-18
6,144 reads
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....
2011-01-18
2,674 reads
Congratulations to the winners in the Professional Development Track Vote for PASS SQLRally. You can see the winners at http://www.sqlpass.org/sqlrally/2011/Agenda/Sessions/SessionsProfessionalDevelopment.aspx.
Now the...
2011-01-18
783 reads
January’s OPASS meeting will be held this Thursday, January 20th at 6pm. We will be meeting at the Hampton Inn,...
2011-01-18
609 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers