Technical Article

RE: data format

  • Reply

Yeah! very nice, kkeeffe...always appreciate someone using "While" loops instead of cursors. Below is your code modified to: 1) Remove @Rowcount variable and use "IF @@Rowcount = 0 Break" instead. It's cheaper. 2) Removed Delete statement and added Where clause "Where Len(Name_) <> 0". Also cheaper, as it's checking a condition instead of modifying a […]


Technical Article

RE: Integration with Dot.Net, UDT's

  • Reply

We do use UDT either. I think it is better to use strong Entity/Attribute data modeling software and let the foreign key migration enforce the data conformity. For non-keys we use LOGICAL ONLY UDT but translate them to standard data types in the physical model. We use ERwin. It is a little pricey but I […]


Technical Article

RE: need help with COUNT

  • Reply

Here's one problem with your script: and Fname LIKE '%%%' First, this selects ALL data from Fname. Second, it overuses the %. Are you trying to get everything from Fname? If so, delete that line. Are you trying to get Fname where there are only three characters? If so, change the theree %'s to three […]



Creating a user for a STONITH resource in vSphere


I previously blogged about how to create a STONITH resource for a pacemaker cluster...

Default event_file path for Extended Events


Foreword Have you ever wondered where the .xel file is saved when you create a...

Query Store Hints in SQL Server 2022


Another neat little feature in SQL Server 2022 is Query Store Hints. This is...

Read the latest Blogs


Display Top N values of a table with calculation next to it

By Soof1234

Hi, In Power BI Report Builder I need to use SSRS code for my...

Package runs in Debug mode but fails otherwise

By Alexp012

Hi We have a SSIS package that uploads data to Blob storage. The package...

Can anyone suggest a plan with backup full and backup log without backup diff ?

By vpmaciel

I need only one backup full at mid night, and one backup log each...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers