sickpup (4/1/2013)

---

Hi all,

Long story short, we had a process that was filling up our log file at an impressive rate (impressive in a bad way). We got everything under control...

ananda.murugesan (3/13/2013)

---

Hi,

Tlog backup failed and no errors are written error log and application logs as well..

when try to editing existing maintenance plan as below errors display

"Microsoft SQL Server Management Studio...

prathibha_aviator (3/13/2013)

---

I have a table which has three columns

create table employees

(

ID int NOT NULL PRIMARY KEY

NAME varchar(10) NULL

EXTENDEDID int NOT NULL IDENTITY(1,1)

)

INSERT INTO employees ( ID, NAME, EXTENDEDID)...

Tony Saucedo (3/4/2013)

---

SQL Server 2008 R2 not starting after moving model database. Any ideas? Error: 945, Severity: 14, State: 2. Any ideas how to correct without reinstalling?

Also Sql 2008 R2...

Seriously?.

I never seen this in my environments of SQLserver 2008 R2. What is...

siggemannen (1/28/2013)

---

Can SQL Server guarantee that if I issue a command like:

INSERT INTO T(...)

SELECT t.a, t.b, 1

FROM sometable t

UNION

SELECT -t.a, t.b, 1

FROM sometable t

, both "sides" of union will retrieve...

purushottam2 (1/27/2013)

---

Production db had the 100 GB of log file. to remove log file i did following steps.

- Deattached Database

- Renamed logfile

- Attached Database with-ought log file.

Above process creates new...

What do you mean by script a large table? Are you referring to data or structure?

foxxo (1/2/2013)

---

Reduce your readbatchsize, it's too high which is why you're seeing the message:

http://www.sqlservergeeks.com/blogs/Abhay_c/sql-server-bi/455/sql-server-fine-tuning-transactional-replication-performance-part-1

I'm thinking of changing the readbatchsize parameter from 5000 to 1000. And see if that makes sense....

tbmabry (1/2/2013)

---

I need to get the emails from the n.Note field, which is a nVarchar(max) column.

I have the following, but I get an error saying "Invalid length parameter passed to...

Gifted question. 7 points for that. Thanks Steve.

Thanks Steve. Wish you a very happy new year.

bommaka.nagarjun (12/5/2012)

---

Hi,

I have a SQL Server database whose data files have been created with...

kaplan71 (12/3/2012)

---

Hello --

One of our systems is running SQL Server 2005, and has a database that was initially 'sized out' at thirty, 30, gigabytes. The space that is currently taken...