if your using SSRS, then you can toggle the visibility of the column using an expression ,

something like

iif(SUM(len(colA))=0 , FALSE, TRUE)

Without data there is not guarantee that this is the best index to create but I am pretty sure its close

Clustered index on wesbiteid

Nonclustered index on Startdate , enddate with...

Could you post your query and execution plan, do you have an index on the month column , is the index being used ?

Me and Jeff have been having a side bar on this discussion and he will be posting his findings shortly.

if your backup completes at t1 then no , if your backup started at t1 then yes

this will not result in a deadlock since both the updates are happening to the same row.

your looking at most blocking and that too should resolve itself as soon...

How many rows does this table have? and have you tried changing the fill factor to 100% before rebuilding the index?

Sorry it took so long , have you tried manually adding the output columns via Advanced editior

When it comes to fetching data from a table, there are many ways it can be done. The SQL optimizer tries to find the best plan within limits, these limits...

You need to use Groups in Windows

Create a Group called Appusers in AD

Add users to the AD Group

Create a Login in SQL Server using the WINDOWS Group AppUsers

Grant the...

Depending on carnality of the value @a_value in Column F

Highly UNQ

Uses NC index and then Key Lookup on Clustered Index to fetch the required output columns

Not very UNQ

Clustered index...

Potential risk

worst case, total drive filaure results in End of the world

Best case , severe performance issue when read and write operations and backups are being performed all the...

I don't think SAP BI Destination is a component provided out of the box , you probably have a custom component installed. Can you provide a screenshot of exactly what...

Although they haven't mentioned it , I think the backups are happening to a different SAN than the ones being used to host the database files ( providing one level...

MickyD (10/29/2015)

---

Jayanth_Kurup (10/29/2015)

---

Login Names and User Names do not have to match , usually when you create a login and then map the login to databases a user with the...