T-SQL Challenges

Technical Article

RE: Transferring Logins to a new server

  • Reply

Before I transfer/copy/restore any database to another server I always use the following to generate sql to create login(s). This makes sure that the sid is the same so that all the user permissions tie up. select 'sp_addlogin '''+name+''',@sid=',sid from syslogins where name = 'username'

2003-06-26

Technical Article

RE: Server Upgrade / Migration

  • Reply

Yep, they'll both have the same name. In the event of disaster recovery I would plan for Server B to have the same name as Server A. I just had a squiz at that article. It's good except the target server has quite a different logical drive layout. Edited by - Mark_Holst on 06/25/2003 6:48:56 […]

2003-06-25

Technical Article

RE: Outer Join with Single Row Result

  • Reply

Do you mean there will be a maximum of three 'child' records per parent record?..... Yes, a maximum of 3 child rows per parent. I had tried aliasing the child rows but there is no specific where clause I can use to limit to a specific selection of the available children. Just retrieving 3 is […]

2003-06-25

1 reads

Technical Article

RE: RAID Recommendations?!?

  • Reply

I apologize for the confusion. Right now I have 4 disks @ 36GB as RAID-5 array. This is devided into C, D Drive letters. 4GB for C and the rest for D. I am going to add 2 disks @ 72 GB each as RAID-1 array. I do not have any file groups other than […]

2003-06-23

1 reads

Blogs

New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters

By

My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Read the latest Blogs

Forums

Case statement with time

By pedroccamara

Hello everyone I hope everyone's ok. I have this query and I'm trying to...

what are the best books to become a SQL developer?

By vpmaciel

what are the best books to become a SQL developer?

what are the best books to become a DBA SQL?

By vpmaciel

what are the best books to become a DBA SQL?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers