Hello I have a table with 13 columns, where column13 is of type bit and has an index (actually, the sole index in this table). I have a simple SELECT...
Hello I have a table called MyTable with an UpdateTimeStamp column (of type datetime). There is an after update trigger that supposedly updates that...
Hello I have a table called MyTable with a field named UpdateTimeStamp (a datetime). I would like to know if it is possible that whenever there is a...
Hello I have a table with a field called UpdateTimeStamp, with a datetime datatype and there is an Index for that field. In the following simple...
Hello Suppose that there is a table MyTable(col1 tinyint, col2 tinyint, col3 int, col4 bigint). What would be the most efficient way of updating col4...
Hello I have a CurrentStock Table with the structure (#StoreCode, #SKU, Stock). I would like to retrieve all SKUs that have at least 5 units in...
Hello Suppose that I have the table BusinessWeek(BiWk char(7), InitialDate date, EndDate date). I want to create a function that given a date, it...
Hello I have a CSV where every single value is surrounded by quotes, even the numbers. I would like to know how to handle this, because the BULK...
Hello I hae read that when using the IN operator, the query engine does not use indexes. So my question is, shouldn't the query engine be smart...
Hello I use the MERGE statement for updating a Local table using a Remote table as the source, and this is made every 30 minutes. The Local table is...
Hello How can I get a resultset with a single column where every row is a Date from a given month from start day to the end? All of this using a...
Hello Suppose that I have a table StockMovement(#ItemCode char(8), Date datetime, Quantity int). I would like that if the Quantity field value is...
Hello Suppose that I have a table called T1 which -among many- has a datetime field named DateType1 and other datetime field named DateType2. Now, in...
Hello I would like to know if someone has attempted to automatically find correlations using data mining techniques over the SQL Profiler data...
Hello Suppose that I have a table with a DateTime column. I would like to retrieve the rows given the year and month, with two added columns: One for...
Hello I would like to know if a I add a new processor to my server the SQL service running there would automatically utilize it or it depends of the...
Hello I have a job run daily that generates a backup (made as a maintenance plan). I would like to automatically compress the backup file and then...
Hello I have just read that the "=" has a better performance than "<>", which makes me think that I should use "NOT =" when trying to express...
Hello I have a job that calls sp_recompile for a given stored procedure every morning at 9am. Sometimes, I have to call sp_recompile again at 6pm...
Hello I have two tables: TransferMaster(#DocID, DocDate, SourceWarehouseID) and TransferDetail(#DocID, #ItemID, TargetWarehouseID, Quantity)....
Separate names with a comma.
