cross apply

Technical Article


  • Article

That said, even though my personal focus is pretty much OO, I still miss stuff. SQL Server 2005 came out with the CROSS APPLY and OUTER APPLY operators and I have just started learning how to use APPLY in the last month or so. When I think I have it figured out, I am fortunate enough that some of you are interested in reading about my understanding of the technology.


7,434 reads

Technical Article

case insensitive password?

  • Topic

Hi, I installed MS SQL Server 2000 + SP2 with default options. It was installed in a mixed mode. Now I noticed that the SQL server login passwords are not case sensitive. i.e. for e.g 'PASSWORD' and 'password' are same. Usually passwords are case sensitive. Why it is like this? Regards Unnic


1 reads

Technical Article

RE: Could not find database table ID 2, name tempdb..

  • Reply

Sorry for asking the bloody obvious, but has tempdb been deleted? As you cannot start the SQL Server service, check in Windows Explorer for existence of C:\Program Files\Microsoft SQL Server\MSSQL\Data\tempdb.mdf (well, this is the default path anyway). Or does the full error message suggest that SQL Server cannot find a certain system table within tempdb? […]


1 reads

Technical Article

RE: Checking for a character

  • Reply

Superfast set based query (0.093 sec for a table of 10000+ records of 40-50 characters): CREATE TABLE [Numbers] ( [PkNumber] [int] IDENTITY (1, 1) NOT NULL , CONSTRAINT [Pk_Number] PRIMARY KEY CLUSTERED ( [PkNumber] ) ON [PRIMARY] ) ON [PRIMARY] GO Declare @i as int set @i = 0 while @i < 8000 begin Insert […]


Technical Article

RE: Is Moving

  • Reply

Best of luck. With the great job you've done with this site so far, the move should go smoothly. You've done all the proper steps...plan it, notifiy users (and family). Now you just have to do it. And if something unexpected should happen, that's part of the IT would and we'll bear with you (at […]


Technical Article

RE: Table last updated??

  • Reply

Not unless you've got some form of datetime field that's set to the current date on an update. Timestamp columns are updated whenever a record is changed, but I don't think it's possible to work them to a date



Flyway Desktop Projects for My PoC


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

Daily Coping 30 Jan 2023


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

Migrating or Recovering a TDE Protected Database 


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

Read the latest Blogs


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,...


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