I wouldn't mind having some sample data to determine if the original primary key actually made sense. As Jeff mentioned a temporal based partition means having some sort of...

I am wondering if the "#TEMPTABLE" you mention is created inside your code, in which this would fall into the realm of a stored procedure. For a simple lookup as...

I realise this has been answered but I did note in your example under options you list what appears to be the result of a triangular join.

I produced exactly those...

It seems we are not aware what version of SQL Server is at play here. Thus the error messages some have encountered. Also no images are in the zip file,...

Remember the clustered index represents the order of the table, the primary key represents what is unique about each row. They are not necessarily the same as you know by...

then I tried it with temp tables (two temp tables then the join) and boom, total execution goes way way down.

not sure what is going on here but I guess...

If you are working inside of SSIS, make certain there are no event handlers behind the scenes overriding what you are trying to do.

Just a quick note I found on Books Online :

https://msdn.microsoft.com/en-us/library/ms177570.aspx

Have a look at the bottom section named restrictions. I see a mention of replication, might this apply to your...

Part of the answer to this question is how many tables and /or columns to existing tables you think could be added? You multiply the size per one row times...

Eirikur Eiriksson (4/6/2015)

---

koti.raavi (4/5/2015)

---

Hi Everyone,

Please see below query

Select ID, ID1,Name, Cname from Customer where ID =(@IDSearch) or ID1 =(@Idsearch)

When i run above query took around 3...

I have also heard the terms 'ansi' and 'ascii' used interchangeably. If that is what you mean then the simple answer is that unicode text starts with a "N" in...

I hope I am understanding your question. Combine the results of the sql provided above with the information presented here :

https://msdn.microsoft.com/en-us/library/bb177899%28v=office.12%29.aspx

I would recommend to use the registry to store a password though the configuration manager. It's a good practice so that the text is not exposed in a file or...

Enjoy_SQL (3/20/2015)

---

If a trigger fires, it works assuming people enter the data each week in order ... if they go back and edit a previous week, it breaks the integrity...

Enjoy_SQL (3/16/2015)

---

Below is the source table, the view, and the trigger on the source table.

What I am finding out now (and someone mentioned before with caution :)) is that any...