Press Release


Technical Article

Jacksonville Free HA Event From Microsoft and SQLServerCentral.com

If you're in Jacksonville next week, whether you’re a developer, DBA or manager, you’ll get something out of this all day SQL Server free event. This event is being run with Microsoft and Idea Integration (Brian from SQLServerCentral.com) and will be at a detailed tech level (no marketing). This all-day session is designed to Get You Started with Microsoft SQL Server 2005 High Availability and gotchas when upgrading to 2005. High availability is a hot topic for most enterprise customers. Any application downtime can impact your business, resulting in revenue loss, customer dissatisfaction, and damaging creditability of their business. These 300 Level sessions will be mostly demos! When you leave this, you should know how to mirror a database and cluster. RSVP required.

You rated this post out of 5. Change rating

2006-06-02

789 reads

Blogs

SQL Server Alerts

By

Don’t Let Trouble Sneak Up on You   Most SQL Servers run quietly. Until...

Prompt AI helping with Auditing

By

I had a conversation with a customer asking this question: how can I tell...

From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO

By

There was a time when the Chief Data Officer lived in the shadows of...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Collation errors...what is best way to deal with it?

By water490

Hi I have a SP that occasionally get this error: Cannot resolve the collation...

Was the index created or not?

By water490

Hi everyone I am getting an error when I create the index but I...

Visit the forum

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 in SQL Server 2022?

See possible answers