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....

No worries, Matt did a very good job explaining the singularity required. Suggest that you look into the overhead of OPENXML, don't' use if it can...

Sean Lange (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 …………………. Just for curiosity...

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 "what are the DAC limitations",...

Koen Verbeeck (8/6/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 …………………. Just...

Jason-368451 (8/6/2014)

---

I have a CSV file that I bulk loaded into a single column staging table.

I need a way to parse proper csv files that are comma delimited with...

I agree, in this case the computed...

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 …………………. Just for curiosity

Thanks a...