Simple One........

Fruit Bowl (Mix of all Fruits), best and fresh food available in canteen.

You can use ALLOW_ROW_LOCKS and ALLOW_PAGE_LOCK Options when you are creating the non clustered index.

when both of these options are on (Default) the Database Engine chooses the appropriate...

when you ask for any sort of help in the forum, pleae provide the table structure and the sample data in the form of insert statements.

Select name,Count(status) From Attendance

where...

Hi,Is the issue resolved? if yes could you tell me the approach that you have taken to resolve. Thanks in advance

Sharth.chalamgari

As i mentioned earlier we have 90 GB of space on the E drive. when we restart the services the backup jobs will work as usual. is there any other...

Congrats Jeff, this will be really inspirational for other sql folks.

Nice article, reminds all the basics once again, Thank you

sharath.chalamgari (8/17/2011)

---

but still the statement in the link you provided says that

"After declaration, all variables are initialized as NULL, unless a value is provided as part of the declaration."

so when...

sharath.chalamgari (8/17/2011)

---

but still the statement in the link you provided says that

"After declaration, all variables are initialized as NULL, unless a value is provided as part of the declaration."

so when...

but still the statement in the link you provided says that

"After declaration, all variables are initialized as NULL, unless a value is provided as part of the declaration."

so when i...

easy one today

Nice article, in our development we will mostly use Procedures for the dataset of the Reports. so we normally use dependents of the table and then change the Procedures accordingly.

Good...

i was got confused my self with the nvarchar(max), then got to know that it supports only fixed length, thanks for the Question.

Simple one 🙂