Tabular Model

Technical Article

Best Practice - Copy Database

  • Topic

Wondering what the best practice or best approach would be to solving a problem.  We are currently migrating from IIS to Sun Java Web Server.  This is being done to address various security flaws in IIS.  So the plan is to move all the applications and database to a development / test environment and run […]

2004-01-27

1 reads

Technical Article

RE: Deletign a log file: Urgent

  • Reply

I use these 2 statements as two different steps in a job to back up the log and then truncate it.  Works well.Step 1BACKUP LOG [MyDB] TO  DISK= 'D:\Backup\MySqlServer\MyDB\MyDbLog.dat'  WITH  NOINIT , RETAINDAYS=2, NOUNLOAD ,  NAME = N'MyDB Translog Backup',  NOSKIP ,  STATS = 10,  NOFORMATStep 2USE master BACKUP LOG MyDB WITH NO_LOG GO USE MyDB […]

2004-01-07

1 reads

Technical Article

RE: Structuring SQL to retrieve data from child recs

  • Reply

weissa, Can you answer jxflagg Last question? I have no clue about what are your presentation requeriments and That makes it harder for me so I am guessing now: Suppose you have TableChild (ChildID int, ParentID int , Property varchar (100)) You Could Do: Declare @strAllChilds varchar(4000) Declare @MasterRecordID int SET @MasterRecordID = X SELECT […]

2003-12-24

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