cross apply

Technical Article

RE: English in Script Comments

  • Reply

Steve mentioned "I typically don't review the scripts when they are submitted because honestly I don't have time". I'm sure this is true of the other site owners as well. Would it be beneficial to the community as whole if there was a group of reviewers that performed this function? I'm sure in a community […]

2004-08-16

Technical Article

RE: Closing an open database

  • Reply

/* To automatically close a db when no users are accessing it */ ALTER DATABASE pubs SET AUTO_CLOSE ON go However when u use the db , it will be opened again ! so what is the exact test that u are doing? consider putting db in dbo use only mode. sp_dboption pubs ,'dbo use […]

2004-01-02

Technical Article

RE: UDF as Computed Column Part 2

  • Reply

Hmmmm... It was with the first script "Create Schema Authorization" but the entire exercise worked fine this morning. The fn_getDuration function is nice little headbanger. Thanks for your assistance.

2003-07-23

Technical Article

RE: Combining Two Grouping Select Statements

  • Reply

quote: To be more specific, I am trying to obtain the total of questionnaires in the query per "WSI" as opposed to the percentage from the whole. This select statement is being called from an ASP page as opposed to in the sql stored procedures etc. I think it would be better if you used […]

2003-06-18

1 reads

Technical Article

RE: interbase vs sql server

  • Reply

Depends whether you want a desktop or an industrial-strength solution. Interbase is fine if all you want is a small discreet desktop datbase solution similar to MSACCESS. If on the other hand you want the speed, power, scalability and robustness offered by a mainstream RDBMS then choose SQL Server over Interbase everyday. Don't get me […]

2003-06-18

1 reads

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