Replication does...

Below is the code for my stored procedure - please take a hard look at where something might go wrong. My own suspicion is in the BCP usage to turn...

tcronin 95651 (7/24/2014)

---

the intention was to remove the reporting server from the sharepoint box entirely and have this on the second instance. I get sharepoint integrated is better, but...

Yes - you can install both multidimensional and tabular instances of SSAS on the same server without any problems. They need to be separate instances but other than that...

Mitch2007 (7/24/2014)

---

Hi all.

I found this code online in order to email oujt a View I have created in SQL 2008 as a CSV file:

EXEC msdb.dbo.sp_send_dbmail

@recipients='MyEmail@MyDomain.com',

...

tcronin 95651 (7/22/2014)

---

I have two reporting services environments. First one is a native running on the same sql 2008r2 box using the 2008r2 box for it's backend. The...

Lempster (7/11/2014)

---

I have a Fact table based on a View. Rather than create a Calculated Measure in the front-end BI application (Tableau), I decided to alter the View to include...

river1 (7/11/2014)

---

Hi,

I have created an alias named Kal on my SQL server 2005 server. I have inserted the right port number on it.

If I connect from 32 bits machines I...

Howard C. BAchtel-438731 (7/9/2014)

---

I am new to MDX queries and have an MDX query that runs fine:

Select

[Measures].[Total Patients Waiting] on columns,

CrossJoin({[ReportDate].[ReportDate].[Report Date].&[20140401]},

{[Facility].[Facility].ALLMEMBERS}) on rows

From WaitTimeEWL

The data updates periodically (currently maximum...

visu.viswanath (7/3/2014)

---

hi,

I am using following query...

SELECT *

FROM OPENROWSET('Microsoft.Ace.OLEDB.12.0', 'Excel 12.0;DATABASE=E:\EXCELFILES\EXCEL_2014.xls',

'Select * from [sheet1$]')

in my sheet one column contains numeric values, but some of the rows...

Depending on how you name your packages and tasks, system variables PackageName and TaskName might help you. Otherwise, you could try storing some addition information external to your package...

WITH MEMBER allows you to create calculated members that you can use in the SELECT statement. This is useful where the calculation doesn't exist in the cube you are...

navie22 (7/1/2014)

---

I am having problem with my script. at first time, it runs fine, but when second time, when their is no data in schema ABC tables, it still make...

Dennisql (6/25/2014)

---

Can nonclustered index be created without first creating clustered index? I guess so. but I read a book it mentioned that nonclustered index will use clustered index to find...

Great - glad to help