Topics
Started by
Posts
Last post
What I am trying to do is return a value that is not changed from the row of the table that was cha…
5 replies
Hi all, I have pasted a query below and I need your suggestions or comments on same. Is there any i…
3 replies
My system has a number of history tables that would give the date that a value has changed. I found…
8 replies
Hi Guys, I am planing to do MCSA – SQL server 2012 certification, which has the following exams. …
7 replies
Perhaps I am confusing this formation with calls to a stored procedure. Isn't it possible to call a…
47 replies
Here is my case, i have a PRODUCTS table create table PRODUCTS ( ID_PRODUCTS CHAR(10) pr…
4 replies
Hello, I'm hoping someone can help me with a SQL query I'm trying to write; I'm relatively new to S…
4 replies
We have a new server with SQL Server 2012. Database mail has been configured and appears to be work…
4 replies
Below are the IO Statistics for a query before and after optimization. IO Stats are different but a…
7 replies
Dear All, I have a query which was using CROSS JOIN (with relations) earlier and now we modifi…
13 replies
Has nolock been depricated in SQL Server 2012, or does the optimizer ignore the no lock and still r…
4 replies
Hi, I have a table in SQL Server 2012 in which data is imported daily. SQL Server 2012 is connected…
1 replies
Hello! I have one stored proc which returns data by querying multiple tables using union clause wit…
16 replies
Hey Everyone, I have a set of IF THEN logic that create additional fields. Does anyone have a grea…
5 replies
Is there a way to track a truncate statement without a trace. Can there be a trigger set up or some…
4 replies
Viewing 15 topics - 4,801 through 4,815 (of 4,978 total)
You must be logged in to create new topics.