Hi

There are different ways of doing this. You can use a function or use the number table method. Lots of info regarding this on the web and this site.

For the...

Well being 30 does not put me in the old people list nor do i have any health issues. Since IT is a sedentary form of work i decided to...

Query does not run in SQL 2005. sysproperties is not there in sql 2005.

If you have full and diff backups you need to restore the latest full backup and the latest diff backup after the full backup. That means 2 backups to restore....

Shrink db will reduce the size of data and log files. Shrink file can be used to target specifically the data or log files.

.mp3 - music database 🙂

If you have a backup strategy involving...

Jeff Moden (5/7/2009)

---

Chirag (5/7/2009)

---

Some time back i got a good offer from a company as a DBA which involved DBA activities and performance tuning.

During the interview process i pointed...

Thankyou for your comments. I get the feeling that i did over do a bit. I will keep this in mind for the next time. 🙂

From SQL 2005 onwards there is a lot of stuff with which xml data can be manipulated.

select name from sys.columns where object_id = object_id('Tablename')

I hv'nt used JSON but xml is a good option. You can pass the xml as a parameter to the procedure and do your checking inside the procedure.

Records cannot be entered as bold. check the font that is set.

Edit: Iam assuming that you are asking about results being shown in bold in query analyzer.

Hi

You can use sys.dm_exec_cached_plans to know the procs executed the most.

Check out this query i got from the web.

SELECT CASE when dbid = 32767

...

Better use a inner join rather than doing the join in the where clause.