Viewing 15 posts - 886 through 900 (of 3,666 total)
Valid points, but if your databases are all on the same server, one customer can still affect others.
As far as disk IO is concerned, there are things you can do...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 17, 2014 at 11:44 am
Picture this .... you get 1 million schools ... 1 million databases to manage!
Would be much easier to manage one database.
I know there's many other points to consider, but from...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 17, 2014 at 11:11 am
You can't do: SELECT @count = (Select COUNT(*) FROM [dbo]. + @TableStat);
You need to build a string that has the query you want to execute, then execute that string.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 16, 2014 at 3:53 pm
I don't like using the error output when I can remove the erroneous data myself. I would do it differently.
I would add a condition split in the data flow to...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 15, 2014 at 2:32 pm
Would the query below be a better starting point for you?
SELECT
DATEPART(Year, [date]) AS [Year]
,DATEPART(Month, [date]) AS [Month]
,SUM(pyd_amount)
FROM paydetail p
WHERE p.itm_code in ('A','B','C','D')
and [date] between '1-1-2014' and '1-31-2014'
ORDER...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 15, 2014 at 2:26 pm
farrukhhameed786 (12/15/2014)
HiPlease Below the query i need to use condition
I need to use in below query how to use
SELECT
ISNULL(EVT.VAL1/NULLIF((EVT.VAL2),0),0) AS ITEM_ID
FROM
EVENT1 EVT
WHERE NAME IN ('JOHN','PATRICK')
You need...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 15, 2014 at 12:29 pm
If you don't see any SSAS database on SQL 2005 then it looks like you are not using it and therefore don't need to install it.
You can install it later...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 15, 2014 at 7:22 am
I'm not aware of anything like that existing.
Sounds like you will have to create your own.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 11, 2014 at 3:41 pm
aliens218 (12/11/2014)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 11, 2014 at 3:37 pm
chulheekim (12/11/2014)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 11, 2014 at 1:44 pm
I don't understand what you mean by "restart".
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 11, 2014 at 9:38 am
Actually, this was a badly worded question.
The question was asking how many rows will be affected. It should have been asking what message will be displayed.
(I got the correct...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 11, 2014 at 8:26 am
Phil Parkin (12/11/2014)
It would probably be easier to use T-SQL to get your data into...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 11, 2014 at 7:33 am
How much do you know about using Integration Services?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 10, 2014 at 3:12 pm
Koen Verbeeck (12/10/2014)
Grant Fritchey (12/10/2014)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
December 10, 2014 at 12:55 pm
Viewing 15 posts - 886 through 900 (of 3,666 total)