ScottPletcher (11/25/2013)

---

Use view "sys.dm_db_index_operational_stats".

Capture the values at the start time, then recapture them at any subsequent time, subtract the two values, and voila, you have the mods that occurred during...

john.chiu (11/25/2013)

---

I was tasked to collect row count information in a system with approx. 500+ tables. They want a way to easily identify which top 20 tables insert the most...

hoolash (11/25/2013)

---

Hi all,

I have a JOIN query that selects data from 3 specific tables, using a common field called "ReservationID". The column I am pulling from one of the tables...

yes it is on the Oracle side; because of the _TS (_TIMESTAMP?) i think that it's the timestamp datatype issue.

pretty sure you can also resolve this by convertint the value...

Aatish Patel (11/25/2013)

---

I create a linked server to Oracle in SQL 2008. tested the connection and it tests successfully.

When I try to query

SELECT top 10 * FROM...

fawad.majid (11/25/2013)

---

No No!

not additional column ... there is a column name RPTBO_HTML column in the table, in the result it getting the same data as other database are but...

fawad.majid (11/25/2013)

---

Hi There..

I have 69 SQL DB servers and every server have identical tables but on three database when I am querying the table it populating the Application version in...

yep linked servers, which include openquery , openrowset, and selecting from four part names, are horribly slow;

my rule of thumb is never to use it when fiddling with...

great job posting the DDL;

in this case, i think using ROW_NUMBER(), and a custom CASE expression to control the special order might work well:

SELECT * FROM

(

SELECT row_number() over(partition by cStudentID,School_Year,CourseID...

Grace09 (11/25/2013)

---

I have SQL Server 2000 database, ran index rebuild job over the weekend, but the data file increase after the index rebuild. How can I regain the space? Thank...

offhand, there's four ways, and i'll list them in order of what i consider ease of use, from easiest to hardest:

1. a pre-built utility to migrate from mySQL to SQL...

i'd say one server, lots of database, one database per application. that's a typical scenario in the real world, very common.

a whole server instance per company doesn't end up...

As my friend Koen is pointing out, home work quesitons like this require you to do the research, the reading and the first attempt at the work itself before you...

also, this is aduplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue...

my best guess, which sucks and makes no sense woithout the sample DDL of the tables, and the trigger you were trying to build:

CREATE TRIGGER TR_Sales_CloneToDepartment On Sales

FOR INSERT

AS

INSERT INTO...