Jacob Wilkins (1/29/2016)

---

From https://msdn.microsoft.com/en-us/library/ms186775.aspx, under "Remarks":

For a given identity property with specific seed/increment,...

OK , but why is the Id incremented and Id = 3 skipped ?

Ta,

Iulian

tom.w.brannon (1/29/2016)

---

I knew that coalesce would return the highest data type but never remember the ordering of that so I thought it was either going to be 10 or divide...

I think the AdventureWorks sample database contains the data and structures you can use to practice.

Check this courses on MVA- Microsoft Virtual Academy:

- Querying Microsoft SQL Server 2012 Databases Jump...

That is excelent, one picture wors 1000 words :-). thanks a lot.

Iulian

Ed Wagner (1/26/2016)

---

Iulian -207023 (1/26/2016)

---

I am looking at the sys.dm_exec_connections & sys.dm_exec_sessions on my local machine but I do not see the sessions & connections from yesterday.

I am...

I am looking at the sys.dm_exec_connections & sys.dm_exec_sessions on my local machine but I do not see the sessions & connections from yesterday.

I am curious if there is...

Nice spot

Quite a few options for CONNECTIONPROPERTY:

net_transport

protocol_type

auth_scheme

local_net_address

local_tcp_port

client_net_address

physical_net_transport

Is there a dmv or something to see all the...

OK, so we have :

COUNT( constant ) is the number of records returned by the query

COUNT( DISTINCT ... ) ...

Hugo Kornelis (11/23/2015)

---

Iulian -207023 (11/23/2015)

---

Is there a naming convention that you can recommend ?

i.e. for user tables tbl_

for user's views vw_

for user's functions f_

for procedures p_

or something like this...

Hugo Kornelis (11/20/2015)

---

patricklambin (11/20/2015)

---

What do you think about this old blog ?

Do you agree with the explanations given by the author to reject the sp_ prefix at the beginning of...

nice one , thx

g.britton (11/4/2015)

---

Iulian -207023 (11/4/2015)

---

g.britton (11/4/2015)

---

Carlo Romagnano (11/4/2015)

---

If I want to be pedant, the right answer is "All of the above".

Because of lacking of batch separator "GO".

If you run the script...

g.britton (11/4/2015)

---

Carlo Romagnano (11/4/2015)

---

If I want to be pedant, the right answer is "All of the above".

Because of lacking of batch separator "GO".

If you run the script no procedure is...

gvoshol 73146 (11/4/2015)

---

I selected "all of the above", knowing I'd probably get it wrong. Because none of them are good practice. You should always check for existence of...