Viewing 15 posts - 331 through 345 (of 356 total)
Great question, thanks
Here is a reference to the compound operators: http://msdn.microsoft.com/en-us/library/cc645922.aspx
Regards,
Iulian
October 29, 2010 at 12:36 am
Sounds good.
I would like to make some exercises on this regard.
What do I need?
Thanks
Iulian
October 28, 2010 at 1:59 am
Hi Raunak, Great idea with this forum
For the beginning:
what is the difference/relationship between Business Intelligence and Business Analytics?
Thanks,
Iulian
October 27, 2010 at 9:11 am
I found this query by googleing and it works, I have got the inventory of the reports.
USE ReportServer
SELECT
CatalogParent.Name ParentName,
Catalog.Name ReportName,
ReportCreatedByUsers.UserName ReportCreatedByUserName,
Catalog.CreationDate ReportCreationDate,
ReportModifiedByUsers.UserName ReportModifiedByUserName,
Catalog.ModifiedDate ReportModifiedDate,
CountExecution.CountStart TotalExecutions,
ExecutionLog.InstanceName LastExecutedInstanceName,
ExecutionLog.UserName LastExecutedUserName,
ExecutionLog.Format LastExecutedFormat,
ExecutionLog.TimeStart LastExecutedTimeStart,
ExecutionLog.TimeEnd LastExecutedTimeEnd,
ExecutionLog.TimeDataRetrieval...
October 27, 2010 at 2:41 am
Hi, Did you tried to restore the database from the backup?
Regards,
Iulian
October 27, 2010 at 2:35 am
You have to use DECLARE statement in order to declare a variable. I tried this
DECLARE @PVC_APPLICATION_NAME VARCHAR(50)
SET @PVC_APPLICATION_NAME='APPLICATION NAME1 '
PRINT @PVC_APPLICATION_NAME
and it showed me as result: "APPLICATION...
October 26, 2010 at 12:01 am
Nice question, thanks.
Here is also a discussion on this topic: http://social.msdn.microsoft.com/Forums/en-US/sqlservicebroker/thread/eca47504-9a8c-4c0f-a4a4-3a56fb5a012b
October 25, 2010 at 11:55 pm
Hi Aaron,
I reached when the meeting has already finished. Is there any way I can see a record?
Thanks a lot,
Iulian
October 25, 2010 at 2:14 pm
The number of the weekend days in the first 4 days of the month can be determined using datepart function, something like this: CASE WHEN DATEPART( WEEKDAY, GETDATE()) BETWEEN...
October 25, 2010 at 5:38 am
Here you will need to determine and add the numbers of weekend days.
and the code will be
4 + [weekend days in the first 4 days of the month]
Regards,
Iulian
October 25, 2010 at 5:08 am
In order to have working days you will need to create a calendar like in this article
Fun with business days, calendar tables, and test-driven development - By Alex Kuznetsov,...
October 25, 2010 at 4:58 am
Nice question, thanks.
Here is an article about the subject also: Instant File Initialization Speeds SQL Server
Iulian
October 25, 2010 at 12:28 am
Great idea!
Using a buffer for data validation before import.
Thanks,
Iulian
October 23, 2010 at 6:52 am
Hi,
Reading this article it does not look very practical to me, but this depends on your needs.
Here is a step by step guide on how to do it on...
October 23, 2010 at 6:36 am
I understand: so it makes admin's life easier, I guess you can even schedule it to empty huge tables very easy and fast then load them with new and...
October 21, 2010 at 2:17 pm
Viewing 15 posts - 331 through 345 (of 356 total)