Viewing 15 posts - 1 through 15 (of 960 total)
if your using SSRS, then you can toggle the visibility of the column using an expression ,
iif(SUM(len(colA))=0 , FALSE, TRUE)
December 10, 2015 at 9:56 pm
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...
December 10, 2015 at 9:54 pm
Could you post your query and execution plan, do you have an index on the month column , is the index being used ?
December 9, 2015 at 10:06 pm
Me and Jeff have been having a side bar on this discussion and he will be posting his findings shortly.
November 23, 2015 at 4:04 am
if your backup completes at t1 then no , if your backup started at t1 then yes
November 21, 2015 at 12:03 am
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...
November 21, 2015 at 12:01 am
How many rows does this table have? and have you tried changing the fill factor to 100% before rebuilding the index?
November 12, 2015 at 2:33 am
Sorry it took so long , have you tried manually adding the output columns via Advanced editior
November 2, 2015 at 5:45 am
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...
October 30, 2015 at 8:02 am
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
October 30, 2015 at 1:58 am
Depending on carnality of the value @a_value in Column F
Uses NC index and then Key Lookup on Clustered Index to fetch the required output columns
Not very UNQ
October 30, 2015 at 1:54 am
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...
October 30, 2015 at 1:48 am
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...
October 30, 2015 at 1:46 am
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...
October 30, 2015 at 1:40 am
October 30, 2015 at 1:29 am