Viewing 15 posts - 1,171 through 1,185 (of 26,487 total)
A better way is to copy out what you want to keep, truncate or drop the original table, copy back in or rename the table to the original name;
August 9, 2018 at 11:10 am
Now something is missing me.
When i run this:
delete from [dbo].[CounterData]
where...
August 9, 2018 at 9:33 am
If you are looking for the algorithm, not sure I can help. You are aware that hashbytes function in SQL Server implements SHA algorithms, you just can't see the code.
August 9, 2018 at 9:20 am
August 9, 2018 at 9:18 am
I think it may come down to the collation of the database where these tests are being run.
August 9, 2018 at 9:09 am
The idea, really, is that you should control the growth of the database instead of letting it grow whenever it needs to grow. And I would stay away from %...
August 8, 2018 at 4:50 pm
August 8, 2018 at 12:11 pm
Eric M Russell - Wednesday, August 8, 2018 8:07 AMI'm talking about code reviews by the DBA.
Only time I get to...
August 8, 2018 at 9:25 am
Try this, uncomment the EXEC statement.
DECLARE @SQLTemplate NVARCHAR(MAX)
, @SQLCmd NVARCHAR(MAX)
, @SQLParm NVARCHAR(MAX) = N'@iViewDef NVARCHAR(MAX)'
, @ViewName NVARCHAR(256)
,...
August 8, 2018 at 8:23 am
+1
I used to do similar things in the past create code to...
August 8, 2018 at 8:14 am
Okay........
It is just the QotD, it isn't rocket science or anything like that.
August 7, 2018 at 4:09 pm
August 7, 2018 at 1:37 pm
Viewing 15 posts - 1,171 through 1,185 (of 26,487 total)