Viewing 15 posts - 4,516 through 4,530 (of 59,067 total)
To Grant's point, we can only guess about such a thing on a totally out-of-context snippet of code.
That, notwithstanding, I have the following comments on this...
First, since (in most cases...
September 30, 2021 at 5:10 pm
Ah... two questions also come to mind.
Don't forget my question about SET IDENTITY_INSERT ON above...
September 30, 2021 at 1:32 pm
Also, plans are not a measure of performance. They're a description of behavior. Be cautious about looking at them as a measurement stick.
+1000000! I will probably not hear more...
September 30, 2021 at 1:23 pm
You can do something like the following link contains to "pre-process" a file. If you can use xp_CmdShell (it's NOT the security risk most will say it is if you...
September 30, 2021 at 2:55 am
That might work if I can figure out how to get line breaks after each row.
CHR(10) should work as the "separator".
September 30, 2021 at 1:53 am
You should also not use SELECT to set the variable - use SET instead:
WHY? What do you base that recommendation on?
September 30, 2021 at 1:46 am
Whomever is doing the security audit should have one of their own.
Also, please try Google on this question. You'll find lots of scripts.
September 30, 2021 at 1:14 am
And, before you move to RDS, consider this... IIRC, you won't be able to restore a single database in the future. Instead, you'll need to restore the entire instance. Actually,...
September 30, 2021 at 12:55 am
Hi All,
Our server has a Datawarehouse database is like 600 GB ( 500 GB for data file only ) and memory is ONLY 8 GB ( 5 GB for...
September 30, 2021 at 12:52 am
Can this be done with a populated table with 24MM rows and 130 fields? I keep getting errors that the tempdb is full (?) I tried copying the table,...
September 30, 2021 at 12:17 am
When y0u create an index, you will need at least as much space in tempdb as the size of the index. In this case, a clustered index IS the...
September 29, 2021 at 11:59 pm
Ok... there's one I didn't know. The trouble for me is that isn't an "improvement in accuracy" for me. It's a 0.0003333 ERROR in ACCURACY to me.
This is almost as...
September 29, 2021 at 11:03 pm
p.s. I'm also the same as Grant... minding my own business and someone walks in and says I've got a week or two to learn SQL. Welcome to the Vini...
September 28, 2021 at 2:14 pm
Hi everyone, I have a brother who just graduated with a programming major. And he seems lost in his own world so i’m here asking y’all where is the...
September 28, 2021 at 2:12 pm
Ok. There's a whole bunch of data in a whole bunch of tables that we have absolutely zero access to. With that in mind, the only problem I'm going to...
September 28, 2021 at 7:33 am
Viewing 15 posts - 4,516 through 4,530 (of 59,067 total)