Viewing 15 posts - 106 through 120 (of 747 total)
On top of the technical reasons not to that have already been mentioned is a business reason: SQL Server is frequently your most expensive storage.
October 25, 2023 at 2:58 pm
Is the primary key on LogID clustered?
Are inserts slow? Updates? Selects? All? Does slow mean seconds/minutes/hours? For how many rows in a transaction?
If the transaction rate is...
September 22, 2023 at 8:30 pm
How many rows? How large is the average error? max?
When you say slow to query/slowing the table down, do you mean select queries? Insert queries? Both? You don't have updates,...
September 22, 2023 at 6:12 pm
Can you provide the link to that article?
September 22, 2023 at 1:37 pm
Layout on that page is rendering most of the article illegible (at least in Chrome).
September 18, 2023 at 8:17 pm
August 30, 2023 at 1:29 pm
replace(replace(col1,char(146),''),char(133),'')
August 25, 2023 at 7:54 pm
Maybe a TVP w/ SortColumnName and Direction/SortOrder columns? SortOrder could be constrained to 'ASC' & 'DESC', or '+' & '-'
With validation in the procedure that SortColumnName is actually a valid...
August 18, 2023 at 3:29 pm
Are your database & the referenced tables/columns using case-sensitive collation? If not, get rid of the UPPER() functions in your where clauses to ensure sargability.
August 17, 2023 at 2:25 pm
Yes, we need to track if a plot is subdivided or merged. Can you explain how to do this?
Maybe an ParentPlot/AncestorPlot table association table, with PlotID, ParentPlotID, ChangeType (SubDivide, Merge),...
August 14, 2023 at 1:20 pm
That looks pretty good.
Police station is an interesting attribute of plot. It seems like that could change over time. Do you care about that historically, or only the current value?
Do...
August 11, 2023 at 1:18 pm
To use out-of-row for LOBs:
EXEC sp_tableoption 'SchemaName.TableName', 'large value types out of row', 1;
To release unused space:
DBCC CLEANTABLE (MyDbName,"MyTableName ", BatchSize)
(BatchSize is optional)
If that...
August 10, 2023 at 1:30 pm
The error is pretty specific:
The configuration file contains an element that is not valid. The #text element is not a configuration file element.
Have you looked at rsreportserver.config (probably @...
August 3, 2023 at 6:49 pm
The stored procedure is the DML.
If you want to know which rows are updated, and the stored procedure isn't updating specified rows (e.g., ID parameter), then you'll probably need trigger(s)...
July 31, 2023 at 6:39 pm
Viewing 15 posts - 106 through 120 (of 747 total)