RE: help
Thanks but no I do not want it to be always .00? example if Elevation/Height (40/3)=13.33 the result should be 13.33 and not 13.00
2004-01-09
Indexing
RE: Selecting Values In One Table Using Another Table As Filter
Right versuses left is nothing more than choice of table reference order and which needs all the data. In this case table 2s data should all be there but those from 1 elminated so only fee data is left. If this case becuase Steve followed name order for reference order RIGHT join applies, for LEFT you need to have […]
2004-01-08
RE: Shrink db grows log
How large your log backup typically from 9PM to 9AM without performing database shrinking?DBCC SHRINKDATABASE moves the data and index pages within the database files and such activites should be logged for recovery purpose.
2004-01-08
2004-01-07
RE: Documentation of system SPs, UDFs, Tables and columns
Hey biker,your avatar is also kinda cool! Although I prefer a Fireblade Now, for the pseudo topic relation:I think Andy Warren mentioned some time ago, he has some SQL Server table maps to share.
2004-01-07
1 reads
Indexing Strategies
Ramesh writes about various indexing strategies that you might use to improve performance.
2004-01-07
10,656 reads
RE: I post wrong place, no one answer??
Our developer complain slow processes, then ask me restore whole db in local server(in our company datacenter) to test compare their application with our power cluster server which sit very long distince from here, developer using from EM show me return from same table only 136 rows from EM for both server , which local server […]
2004-01-06
RE: Sub-Select Wierdness
Not quite what was meant. The original subquery evaluates to a (possibly repeated) set of all the code values from table1. Thus the condition "IN" always evaluates to true. The subquery does not itself evaluate to true. The change you propose would almost certainly fail as it would check for code values that are "IN" […]
2004-01-03
RE: Multi-statement table-valued UDF problem
Äh, now I'm really confused! I still believe my post was not targeted to the original question. Did we find a solution or not? Frank http://www.insidesql.de http://www.familienzirkus.de
2004-01-03
1 reads
RE: NOT NULL CONSTRAINT
Thanks - But if I can't figure out how to name the CONSTRAINT in the first place, I won't be able to rename it either. If I list my constraints by name, I don't see any of the "NOT NULL" consraints I have created, so SQL must not really treat them as a constraint.   SELECT […]
2003-12-23
Blogs
Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers