Forum Replies Created
Viewing 15 posts - 1 through 15 (of 149 total)
-
RE: Relation table
You need to switch your perspective on how you approach the data. You seems to be looking at it from the "many" side of a relationship. Conceptually, there are no...
Wes
(A solid design is always preferable to a creative workaround) -
RE: Get Temp Table definition
Apparently with some data types or some SQL versions, some columns may be duplicated with a sysname datatype. I've submitted an update to the original script, but it may take...
Wes
(A solid design is always preferable to a creative workaround) -
RE: Date Ranges - Simple, but seemingly impossible
Vegeta7 - Wednesday, November 22, 2017 3:50 AMWhat is the ListPrice/FinalPrice of...
Wes
(A solid design is always preferable to a creative workaround) -
RE: Date Ranges - Simple, but seemingly impossible
Vegeta7 - Tuesday, November 21, 2017 8:29 AMWes
(A solid design is always preferable to a creative workaround) -
RE: Date Ranges - Simple, but seemingly impossible
Vegeta7 - Tuesday, November 21, 2017 5:36 AMWes
(A solid design is always preferable to a creative workaround) -
RE: how optimize update query which has column store index on all coumn and one non clustered index on the same column
I would consider updating once daily to be sporadic, rather than a traditional OLTP model. It is feasible to create a process to handle updating the data and then clean-up...
Wes
(A solid design is always preferable to a creative workaround) -
RE: Date Ranges - Simple, but seemingly impossible
Vegeta7 - Sunday, November 5, 2017 6:52 PMWes
(A solid design is always preferable to a creative workaround) -
RE: how optimize update query which has column store index on all coumn and one non clustered index on the same column
Updates to a column store are not a good idea. Column store handles Inserts just fine, but Updates and Deletes slow the entire table access down. Column stores were made to...
Wes
(A solid design is always preferable to a creative workaround) -
RE: Can we use "Between" operator for a VARCHAR column?
BETWEEN on a character column works different than it would with numeric or date/time columns
'0'
'1'
'111111111'
'2'
'2222222'WHERE col BETWEEN '1' AND '2'
would return:Wes
(A solid design is always preferable to a creative workaround) -
RE: Drop Constraint, Field is not a constraint
You'll save yourself some time and headaches if you figure out your datetime conversion issue without the constraints. The best way to do that would be to create a new...Wes
(A solid design is always preferable to a creative workaround) -
RE: from today to last one month data
1 month != 30 days != 4 weeks. Make sure you understand the impact the different intervals can have on your data. Also be aware of the how the between clause...
Wes
(A solid design is always preferable to a creative workaround) -
RE: A Window Function question...
kevaburg - Thursday, September 28, 2017 8:38 AM
I can't understand why I am getting a different result set...
Wes
(A solid design is always preferable to a creative workaround) -
RE: High level performance report aimed at senior management
lassell - Friday, July 21, 2017 3:47 PMWes
(A solid design is always preferable to a creative workaround) -
RE: Cursor Performance
burfos - Wednesday, July 26, 2017 6:46 PMWes
(A solid design is always preferable to a creative workaround) -
RE: Integer to Big Integer and foreign keys
if storage allows, I'd SELECT INTO a new table with the column data type updated, then drop the old table and rename the new table to the old name.
In...Wes
(A solid design is always preferable to a creative workaround)
Viewing 15 posts - 1 through 15 (of 149 total)