Topics
Started by
Posts
Last post
Ok the WHERE clause is a Unique index. If I run the SELECT / FROM / JOIN's I get data returned no p…
17 replies
I'm fairly new to SQL and have become completely stuck in trying to do this: I want to update a col…
3 replies
Can someone recommend a (free?) tool to format TSQL Code. Ideally, it should be something working i…
16 replies
Here's my scenario. I have a table that looks something like this: CREATE TABLE [dbo].[Logs]( [ro…
9 replies
Was watching Brent Ozar explain performance tuning today (Great! Highly recommended!!) and it made …
6 replies
Ok, here is what I'm faced with. I have a number of patients that need to be assigned to doctors in…
2 replies
Hi All, I only have five categories in my table. I don't have any other data in my table: [Code] Ta…
5 replies
experts, how to exclude the negative value in this OT calculation, ,CalcPart AS ( SELECT departm…
9 replies
Hello all, I am looking for validation and help on this issue, as it's driving me absolutely nuts..…
5 replies
I was working in the "Modify" script of a stored procedure just now. I accidentally selected only a…
22 replies
Hi All, I have a table and I have a column that has data like below Tabl1 col1 Base 1 2 3 4 I need …
2 replies
I have a database with about 2,000,000 objects in it. Yes I know its lots but this is what I have …
9 replies
Hi all I have a question about concurrency. Let me provide some set-up code first. DROP TABLE IF EX…
24 replies
I have to Create a Store Procedure named AddToCart.This procedure should take CustomerId, productId…
4 replies
Here is something I found this morning. Since indexed views are used in queries that do not explici…
1 replies
Viewing 15 topics - 2,926 through 2,940 (of 3,062 total)
You must be logged in to create new topics.