INSERT INTO PseudoTable VALUES ('Tear,Bike,Monkey')

SELECT * FROM PseudoTable WHERE Item LIKE '%tea%'

1 row returned.

INSERT INTO PseudoTable VALUES ('Tear')

INSERT INTO PseudoTable VALUES ('Bike')

INSERT INTO PseudoTable VALUES ('Monkey')

SELECT * FROM PseudoTable WHERE...

shanghaigirl-1125377 (2/4/2013)

---

I am trying to observe the graphic execution plan, but my query is big. Is there any way that I can turn off the top part of the...

SELECT

SUSER_SNAME(owner_sid),

*

FROM

msdb..sysjobs

WHERE

SUSER_SNAME(owner_sid) = 'NT AUTHORITY\SYSTEM'

You need to make sure that the new data type is compatible with IDENTITY.

Identity column must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a...

Why?

Yes, in the connection string...

The key is here:

and this article will help you fix it:

http://www.sqldbadiaries.com/2010/07/15/how-to-resolve-missing-msi-or-msp-packages-during-sql-server-service-packs-hotfix-or-cumulative-updates/

Hardly even scratched the surface.

My favourite is

SELECT modification_counter

FROM sys.dm_db_stats_properties

http://eohmicrosoft.blogspot.com/2012/12/heaps-of-trouble.html

Just a bit longer than on the 2nd largest database.

GilaMonster (2/1/2013)

---

asmita.patel (2/1/2013)

---

Use "With (nolock)" hint with table name in query,

for example

select a.*

from <<tbl_aa>> a with (nolock)

Join <<tbl_bb>> b with (nolock) on a.aa_id = b.bb_id

--Note: You need...

For DbMail I always use...

Thanks, I failed at Google and hoped everyone would...

Wrong.

What are you trying to accomplish?

What happens when the customer is called Rachel?