Article below explains this in simple terms:

http://www.practicalsqldba.com/2012/09/sql-server-understanding-gam-and-sgam.html

Parameter formatting is not supported in SSRS. You can not control the parameter field size, positions.

Anybody? Appreciate your response!

rambilla4 (6/3/2009)

---

Thanks,

I went through the link http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/f98cf41a-a1c7-4839-b27a-df0b13908415 and changed the fixed ip address to all unassigned in default website properties in IIS BUT it did not work for...

Alternately, You can execute sp_dropserver for all linked servers using the database cursor. The following example shows how to do this.

DECLARE @sql NVARCHAR(MAX)

DECLARE db_cursor CURSOR...

This example removes the remote server servername and all associated remote logins from the local SQL Server.

sp_dropserver 'servername', 'droplogins'

Let me work out something for you this long week end 🙂

Certification will definitely get you more money but beware that expectations will also be high on job from a certified professional. If you don't cope up with those, you are...

Have you read wiki? http://en.wikipedia.org/wiki/Database_normalization

Also Refer these links:

http://www.dotnetspider.com/forum/161909-Any-one-explain-roles-5-normal-forms.aspx

http://blog.todmeansfox.com/2007/12/04/database-design-4th-and-5th-normal-forms/

I've few references for you:

SQL 2005/ 2008,

http://saveadba.blogspot.com/2012/02/remove-data-log-file.html

SQL 2012,

http://technet.microsoft.com/en-us/library/ms175574.aspx

http://www.google.com/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=3&cad=rja&ved=0CDcQFjAC&url=http%3A%2F%2Fsqlserverzest.com%2F2013%2F05%2F06%2Fhow-to-remove-extra-tempdb-data-files-and-log-files%2F&ei=ZIMeUv_GIeivsASw-IHQDQ&usg=AFQjCNG_enFBkxlzNed4WnQodJp8M8DUjA&sig2=R21ce0etPtxd0Sj8WQJKjw&bvm=bv.51156542,d.cWc

I hope this helps you out.

Following links might be of help to you:

http://technet.microsoft.com/en-us/library/ms178642(v=sql.90).aspx

http://technet.microsoft.com/en-us/library/ms141724.aspx

There are lots of good articles on technet that you can refer to.

If you can specify your actual doubts,...

It's always benefitial to know the previous versions, but that would be more helpful if you are in support role or migartion project and you are willing to engage in...

Code below will return Thursday from the current week for the @Date supplied. You can modify your where clause to use this date as FROM DATE and DATEADD(DAY,-7, THISDATE) as...

Sean Lange (8/28/2013)

---

Snigdha Vartak (8/28/2013)

---

ChrisM@Work (8/27/2013)

---

Why are you using IN and not = for these comparisons?

SV00300.CUSTNMBR in (@CUSTNMBR)

or SV00300.LOCATNNM in (@LOCATNNM)

or SV00300.Contract_Number in (@Contract_Number)

If any of these variables are a...

ChrisM@Work (8/27/2013)

---

Why are you using IN and not = for these comparisons?

SV00300.CUSTNMBR in (@CUSTNMBR)

or SV00300.LOCATNNM in (@LOCATNNM)

or SV00300.Contract_Number in (@Contract_Number)

If any of these variables are a comma-delimited list, they won't...