R Language

Technical Article

RE: SQL SERVER AGENT ERROR

  • Reply

Can forum participants tell me if the following would possibly have an adverse impact:a.  an OS backup in progress which was temporarily reading the event file.b.  a virus checker which might have been reading the event logc. a remote reader of the server's event logd.  an OS search type function which was scanning the event log for […]

2004-03-19

1 reads

Technical Article

RE: Return multiple rows from a cursor with just one fetch

  • Reply

You can do 10 fetches. But this will generate 10 result sets ... :create procedure aa  @rowset integer as begin  SET NOCOUNT ON  DECLARE @pos integer, @co int DECLARE cPartners SCROLL CURSOR FOR SELECT * FROM partners    OPEN cPartners    set @pos = @rowset * 10  set @co = 0  goto FETCHNEXT  while @co < […]

2004-03-18

Blogs

Flyway Desktop Projects for My PoC

By

In a previous post, I set up the basic databases for the PoC project...

Daily Coping 30 Jan 2023

By

Today’s coping tip is to plan something fun and invite others to join you....

Migrating or Recovering a TDE Protected Database 

By

When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

Read the latest Blogs

Forums

Database copies (cross environment) and sizing strategies for 2019

By MyDoggieJessie

I'm sure this has been asked many, many, many times and hoping several optimal...

TSQL to determine status of subscription reinitialization

By ratbak

How do I determine the initialization status of a subscription with T-SQL -- i.e,...

migration

By sqlguru

Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers