object_id with table created by mistake with schema name

OBJECT_ID(N'blah.[blah.boo]')


brackets around the whole name worked

Could not load type MvcApplication

just restarted VS

varchar(max) > 4000 characters

only with casting

asynchronous <> multithreaded

here

changing recovery plan

I coudnt do it with the graphical tools because the log was full

this worked

ALTER DATABASE blah set recovery simple

DBCC SHRINKFILE

uses the logical name

even the mighty can fail

object_id needs the schema

ouch and duh

GO's Kill variables

I learned the hard way

An aggregate may not appear in the set list of an UPDATE statement

i just used a CTE

wireless mouse

can be impacted by objects like a phone or keyboard in between computer and mouse

" works like [ in sql server

create table xxxxxx ("x x" int)
insert into xxxxxx values (456)
select [x x] from xxxxxx

select "x x" from xxxxxx

sql server computed column with case

blah as case when ...