Technical Article

RE: Best Practices for Database Design

  • Reply

I, for one don't care what the iso standard says, they are wrong.  A table does not represent a set of entities.  Tables represent a single predicate function.  So the Employee table with the following attributes:EmpNo, FirstName, LastName, DeptNo, Address,...MEANS literally "Employee (EmpNo) has a first name of (FirstName), a last  name of (LastName), works […]


Technical Article

RE: Applying Password to SA Account

  • Reply

Brian,Don't forget to turn on your pager after that.People who install SQL server with a blank password tend to use it in the applications for connection strings. Those applications will not be able to connect to the database after you change the password. Be prepared to explain things to them.Another thing: Some (me included) have their Enterprise […]


Technical Article

RE: 20 % records

  • Reply

Ah! Thought so when I looked at the code as it did not look like traditional sql server. Unfortunately I have not used Oracle and cannot help you, maybe someone else on the forum can. Sorry I cannot be of more help


Technical Article

RE: What is starting this backup

  • Reply

Got to some job that is running it. Could be a job running from somenoe's desk as well (scheduled tasks). Run a trace (profile ) for that time and see what you get. Steve Jones The Best of SQL Server 2002 -


Technical Article

RE: Finding & removing a space from a string

  • Reply

Now why did the multiple spaces get removed? 'Have___a__Nice_day!' to 'Have_a_nice_day!' When I wrote this originally I was scrubbing some data that had a ton of problems like this. It had been converted by several someone elses before me and they had concatinated a bunch of fields with little to no regard for spacing.


Technical Article

RE: Sp_Executesql ntext

  • Reply

Here is a sproc I wrote to handle a similar problem: /* This can execute dynamically generated SQL statements up to approx 156000 chars in length. Since you can't pass this as a variable the proc takes the table and fieldname of a text value to execute. A where statement can be included and should […]


1 reads


InvalidAbfsRestOperationException in Azure Synapse notebook


Problem The first issue that developers in my team noticed was when they tried...

What do we want to achieve by encrypting our data?


On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022


Today’s coping tip is to look for new reasons to be hopeful, even in...

Read the latest Blogs


log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Optimization for Single Table with Thousands of Concurrent Updates

By keith.west-982594

I have a table with 5 million records and each record requires a "Value"...

Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers