Spatial

Technical Article

RE: A future for stored procedures?

  • Reply

Does Bruce Powell not realise that cursors are slow only when compared with set based SQL statements? They are probably quick compare with running the loop over a client recordset. Also Bruce should remember that source code control is not limited to C# etc. In my last 2 projects we used VSS for all sprocs […]

2004-08-18

Technical Article

RE: SQL Backup & Third party backup software

  • Reply

#1 SQL Server Backup commands work. They will ALWAYS work with SQL Server. PERIOD.#2 There is 3rd Party backup software that works just fine (for now) with SQL Server. They may continue to work when there are changes/upgrades to SQL Server - but they may not. Do you want to take the chance?#3 I know this […]

2004-07-29

Technical Article

RE: splitting 1 field into multiple fields

  • Reply

Just a comment on the subject of name parsing.  The last word in the string is not necessarily the surname.  For example, the surname "Saint Raymond" is 2 words.  Also, the first word is not necessarily the entire first name.  My friends "first name" is "Mary Dee".  As someone who constantly gets sorted into the […]

2004-07-28

Technical Article

RE: Lookup Table Design

  • Reply

Ok, I am sorry - not really - but this is design madness.  Seperate tables for each lookup table.  Surrogate int keys when appropriate (almost always).  This keeps referential integrity possible - hello thats the point of a relational database.ISO codes - give them a column with a unique constraint.Never, never, never design anything that […]

2004-07-27

Technical Article

RE: Port 1433 and 1434 Blocked

  • Reply

Thanks Brian. I downloaded Microsoft's .NET based SQL Web Data Administration Tool. It allowed me to see the databases but gives me a server.timeout when I try to view the contents (tables). Doesn't life just make you wanna cry sometimes?

2004-07-27

Technical Article

RE: Executing SQL Command???

  • Reply

Hi,Try the code given below.DECLARE @filterCriteria varchar DECLARE @filterCMD varchar declare @sql1 nvarchar(200) set @filterCriteria = 'w' IF @filterCriteria LIKE 'W' set @filterCMD=' DESCRIP LIKE ''%closed%'' or DESCRIP LIKE ''%deny%'' or DESCRIP like ''%withdrawn%'' ' set @sql1='select accountID from TEMP_TABLE WHERE ' + @filterCMD exec sp_executesql @sql1Hope this solves the issue.Nivedita Sundar.N

2004-07-23

Technical Article

RE: Merge replication error, foreign keys

  • Reply

Was a new snapshot recently generated which included object changes?  If so, and the snapshot is being applied then:When subscribers are set up their either already have the schema and data, or the schema is pushed to them "yes, initialize the schema and data".  If when the subscription is set up the "yes, initialize the […]

2004-07-22

Blogs

Hyperconverged storage tuning tip for SQL Server

By

We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022

By

Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight

By

This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs

Forums

Restore takes forever

By Edvard Korsbæk

Hi all! I have som pretty smal databases - the backup is app. 250...

DML Trigger Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Limits

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

By Tonie Huizer

Comments posted to this topic are about the item A week in Seattle in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers