They don't need gophers to dig holes in Ukrainian roads.

All the holes are predug by the previous generations.

Locals even give names to the most remarkable of the holes. Like moon...

1 column value is json there are 4 other columns . the json value is stored as nvarchar(max) .i will convert the whole data for a day as 1 xml...

Did you ever consider using a relational database?

I heard they have a fascinating feature named "data normalization".

Being destined appropriately, such a database would take from 5 to 10 times less...

Several things.

1. Always use NOT EXISTS instead of NOT IN.

2. Always use aliases and make sure you don't use identical aliases for 2or more tables mentioned in the query.

If the...

What does it say when you run "kill 59"?

Online shopping leaves number of traces.

Which can be used in police investigation in case of a fraud.

In Australia till now a stranger could enter a shop, present probably stolen or...

Last year Aussies passed the law which makes it illegal for shops to accept credit card payments without a PIN.

Not sure when this legislation comes to power - this...

Xsevensinzx,

"discovering patterns in large data sets" - what?

You have stored your data for long enough so it managed to reach the level of large data sets and only after that...

"Data mining"

What does this term say to you about the industry?

What whoud you say about a mechanic who does parts mining in a huge bag where all arriving parts go...

Keep in mind - if a modified index was not used in the cached plan then recreating it won't necessarily change the query behaviour.

Stored plan will be used until it's...

[Code]Create Index IXTEST2 on SDE_Geometry9 (sde_State_ID)

with(drop_existing=on)[/code]

You missed the second column - Geometry_ID - in this index

In this index:

create index IXTEST4 on sde_geometry9 (Geometry_ID,sde_State_id)

with(drop_Existing=on)

sde_State_id must be the leading column:

(sde_State_id , Geometry_ID)

shannonphillips,

You have duplicates in newly loaded records.

You need first to find which records have duplicate PK values:

SELECT

[Computer Name] ...

I've wrote an article describing the method of age calculations expressed on all sorts of formats:

http://www.sqlservercentral.com/articles/Datetime+conversions/153316/

Amongst others, it can return a date difference in days-hours-minutes-seconds format.

And it does...

Are there only 2 columns in dbo.Tbl_ComputerInventory?