Sean Lange (7/23/2012)

---

weston_086 (7/23/2012)

---

I have two inputs “address” and “net” . I may have to convert these two inputs into binary form. And then apply logic...

The OP may be trying to avoid off page storage of certain parts of data which VARCHAR(MAX)...

depending on what you need to do, MS Access can be used however a custom written front end would also work. depends on how and what you want to...

Dumb Phones

Have you tried downloading the.net 3.5 stand alone installed not the Sql install

i would try installing .net 3.5 first before running the 2k8 express installer. im running windows 7 pro with 2k8R2 express installed just fine. works great for the...

Sqlism (7/20/2012)

---

Can we create server level roles in 2008R2?

I am not getting option 'New Server Role' when i right click server roles.

But How come this document shows can do it.

http://cm-bloggers.blogspot.com/2010/12/creating-user-defined-server-role-in.html

Thanks...

St Louis

Second Base

week after you leave and forget the...

yep you got that part right. it took me a little while to fully grasp CTE's but looks like you got it.

since you are working with nested cursors it makes sure you...

you can use a roll your own solution using partioned views http://msdn.microsoft.com/en-us/library/ms190019(v=sql.105).aspx, it may take some work to get the large table broken into the new tables but you can...

are there differences in what is running on the servers?? are all the indexes the same?? there is so much that can be going on here.

please see this link...

THE-FHA (7/20/2012)

---

SCENARIO,

i have tbl1, tbl2,tbl3 in qa and prod.

tbl1(id int identity(1,1),DomainName varchar(250),Daate datetime,results varchar(20))

tbl2(id int identity(1,1),tbl1_id int,Desc varchar(max))

tbl3(id int identity(1,1) ,tbl2_id int,comment varchar(max))

At this point i assume we all understand...