Chandhini (9/1/2009)

---

Hi,

In my Database, i need to create two different roles to access the db. one is for application and the other one is for development.

For application -...

here's the example i always reference from my snippets:

DECLARE @var VARBINARY(128),

@res NVARCHAR(64)

SET @var = CAST(N'Hello World' AS VARBINARY(128))

PRINT @var

--results: 0x480065006C006C006F00200057006F0072006C006400

SET @res =...

i don't use complex foreign keys , but here is an example i whipped up for the syntax:

this foreign key references two columns in the parent table...limit is 16 i...

gboyer (8/31/2009)

---

All,

I am trying to find a count on all records in a table that have more the 2 numbers after the decimal point in an Amount Column. The field...

Scott Solice (8/31/2009)

---

I have an ntext column that contains the full text of an rdl object. I need to update every occurrence of Parameters!AnyParm.Value with Parameters!AnyParm.Label.

I could use Replace, Stuff,...

give us more info,

sounds like the query is big, so

save the actual query as a text file, and show us the estimated execution plan, saved as a .sqlplan file....

is there a performance problem or something that really requires those threads to be killed, or is it something you noticed and it bothers you?

a sleeping thread is not necessarily...

not enough information to give anything but a generalized guess;

There's two obvious places there is a slowdown :

if your web pages are in .NET, they are not compiled/loaded into memory...

Faye Fouladi (8/31/2009)

---

I have a classic asp page that is accessed via different pages. In some situations the:

Request.QueryString("Contract_ID") is a vchar(100) and sometimes is coming a GUID.

When it is vchar(100)...

here's one I use that was posted by Jesse Roberge ; note this one features the 2005 option where you can INCLUDE other columns in the page data so it...

well there are two ways to do it via TSQL;

the preferred way is like this:

ALTER LOGIN Victoria WITH PASSWORD = 'B3r1000d#2-36';

the old procedure sp_password can be used as well,a t...

I'd seen this before;

here's how i've done it, and i broke it down to help everyone understand.

the way it works is the first 3 digits is the century julian offset,...

Grant Fritchey, who contributes a ton of time helping people here on SSC wrote a couple of ebooks that you can download for free right here on SSC:

SQL Server...

Glad my example worked out for you;

sometimes it's the forest and the trees...hard to see the solution until you step back a bit.

i saw you are using functions that return...

would something like this be a good idea to create a stored procedure with those commands, and have EXECUTE AS with sysadmin rights, then grant rights to the proc for...