SQLRNNR (8/11/2014)

---

Somebody must have broken...

Ran it on 2K8 and reproduced your described results, don't have 2K12 at hand but there is some difference in...

With Packets: 1,441, Acks: 4,025, looks like a congestion somewhere:-D

😎

Something not right here, copyright owner with only water marked images! How on earth did you acquire the copyright?

😎

thiensyh (8/11/2014)

---

thanks bro, it's work like a charm!

Assume now my current date in table A, entity field is char

table data like below , but data in B & C...

There are quite few ways of doing this, here is one that uses left outer joins and a case statement:

😎

USE tempdb;

GO

/*

Table A - data example

Idno Entity Flag

1 1 y

2 1...

Quick question, I ran the code on SQL Server 2014 and it didn't show the behaviour described. What version of SQL Server (@@VERSION) are you on?

😎

LutzM (8/10/2014)

---

I'd like to change Eirikurs 2nd method just slightly to cover partitioned tables, too:

CREATE FUNCTION dbo.FN_COUNT_ROWS2

(

@TABLE_NAME NVARCHAR(128)

)

RETURNS TABLE

AS

RETURN

SELECT SUM(rows) AS ROW_COUNT FROM sys.partitions

WHERE object_id...

mayankminawat (8/9/2014)

---

Hello everyone-

I'm trying to create a simple function that will do a count on a table. I want to pass the table name in form of a parameter to...

arnipetursson (8/8/2014)

---

SQLRNNR (8/7/2014)

---

sqldriver (8/7/2014)

---

Eirikur Eiriksson (8/6/2014)

---

Jeff Moden (8/5/2014)

---

rajeshn29.dba (8/5/2014)

---

Hi Friends,

I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………....

GilaMonster (8/6/2014)

---

Luis Cazares (8/6/2014)

---

Eirikur Eiriksson (8/6/2014)

---

benjamin.reyes (8/6/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Grant Fritchey (8/5/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Guess one has to differentiate between five years of work and five years worth of experience. Questions like...

Edit: Duplicate

kherald69 (8/8/2014)

---

Ok, I just have to toss a wrench into the logic here.

Since we are talking about birthdays, what if the person is over 100 years old? This logic...

SQLRNNR (8/6/2014)

---

GilaMonster (8/6/2014)

---

Luis Cazares (8/6/2014)

---

Eirikur Eiriksson (8/6/2014)

---

benjamin.reyes (8/6/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Grant Fritchey (8/5/2014)

---

Eirikur Eiriksson (8/5/2014)

---

Guess one has to differentiate between five years of work and five years worth of experience. Questions...

Stefan Krzywicki (8/6/2014)

---

Well, it finally happened. I've been threatened with it my entire career. You hear about it in meetings all the time, but you figure it is just hyperbole....