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

whether the command was run with ONLINE or not is not saved anywhere, I'm pretty sure.

peek at this scripting example, it essentially the same way i do it:

http://www.sqlservercentral.com/scripts/Indexing/63620/

generate the script...

the size of the vendor database is one of the things i'd like to know up front;

that's a decent initial indicator for me.

if the entire database is say, 500 meg,...

abhas (11/22/2013)

---

Hi All,

I am ahving a table which contains around 150 columns and millions of rows.

Now I am facing challenge to find among those which records are updated?

there is no...

RTaylor2208 (11/22/2013)

---

A few questions:

1. If you run the trace without filters for a short period of time do you see any of the events you want to capture being...

this is much better:

IF EXISTS (SELECT OBJECT_ID('tempdb.dbo.#tmp'))

DROP TABLE #tmp

CREATE TABLE [dbo].[#tmp] (

[DBName] NVARCHAR(128) ...