ScottPletcher

Forum Replies Created

Viewing 15 posts - 2,431 through 2,445 (of 7,613 total)

Reply To: Concatenating to a string

Phil Parkin wrote:

I'd make it less cluttered by using a variable for the literal single quote:

DECLARE @H CHAR(1) = '''';

the CONCAT version then becomes something like this:

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

March 19, 2020 at 7:53 pm

#3735699

Reply To: Concatenating to a string

'''' + p.firstname + ''',''' +
p.lastname + ''',''' +
i.city + ''',''' +
t.stateAbbrveation + ''',''' +
Convert(char(5), c.peopleId) + ''''
as insert_string

March 19, 2020 at 5:00 pm

#3735648

Reply To: Restore

Every SQL database restore must start with a full backup restore.

After that, you can, if you want to, restore a differential backup (that was taken after the full backup you...

March 17, 2020 at 7:44 pm

#3735135

Reply To: SELECT from COLUMN if exists

Use this to generate the SELECT statements to review. After you've verified the statements, run them if / as you see fit.

DECLARE @DTCHANGEDON_found bit
DECLARE @DTCREATEDON_found bit
DECLARE @end_date...

March 17, 2020 at 7:24 pm

#3735128

Reply To: Get a couple fruits

You really should start using the new syntax, with parentheses around the row count:

SELECT TOP (2) *

FROM STRING_SPLIT(@s, ',') AS ss

March 17, 2020 at 2:42 pm

#3735037

Reply To: DBCC SHRINKFILE EMPTYFILE Running REALLY Slow

Make sure you pre-allocate enough log space to handle any logging required. If the log file has to grow dynamically, that will be very slow.

Make sure the new data files...

March 16, 2020 at 9:48 pm

#3734866

Reply To: WITH Query definition not working

Maybe a permissions issue? I don't see why drives wouldn't show up for that query.

That code is extremely inefficient though, since it pulls drive info once for every file, instead...

March 16, 2020 at 9:37 pm

#3734863

Reply To: TDE related questions

Ultimately any part of a disk drive file can be corrupted (or attacked?). A bad controller, etc., can cause unexpected corruption.

Again, it's my understanding that there is no way to...

March 16, 2020 at 7:39 pm

#3734839

Reply To: Could you list db modeling tools you use on daily basis?

It's very difficult for many people to split the logical and physical design. But, it's critical to a good design that you keep the two separate. Getting a developer involved...

March 16, 2020 at 7:36 pm

#3734838

Reply To: TDE related questions

As I understand it, if you lose the certificate, you can't read the data, period. Back up that certificate and make sure you can restore it!

March 16, 2020 at 6:43 pm

#3734823

Reply To: Could you list db modeling tools you use on daily basis?

IIRC, from the one time long ago I looked at SQL Diagrams, it is only a physical design, there is no separation of logical and physical. If you don't distinguish...

March 16, 2020 at 3:46 pm

#3734768

Reply To: Scalar function too slow - Calculated field in column based on another columns

I would think you could summarize the data just once, for all BSP ranges and WIN/LOSS combos, then join to that, if needed, to get the final result. I can...

March 16, 2020 at 3:34 pm

#3734763