Viewing 15 posts - 601 through 615 (of 3,666 total)
Lynn Pettis (7/1/2015)
Look at the tables that grow the quickest and the causes of this.
Uh, users using the system? Isn't that...
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]
July 1, 2015 at 8:15 am
Jeff Moden (7/1/2015)
Ed Wagner (6/30/2015)
Alvin Ramard (6/30/2015)
Jeff Moden (6/30/2015)
Steve Jones - SSC Editor (6/30/2015)
GoofyGuy (6/30/2015)
None of the following are technical questions, they're just simple and conversational, but they reveal a...
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]
July 1, 2015 at 7:29 am
kapil_kk (7/1/2015)
you can try below this query :
SELECT OrderId, TaskID, MAX(SerialNo)SerialNo
FROM table_name
GROUP BY OrderId, TaskId
Isn't that what I already said?
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]
July 1, 2015 at 7:18 am
Jeff Moden (6/30/2015)
Steve Jones - SSC Editor (6/30/2015)
GoofyGuy (6/30/2015)
None of the following are technical questions, they're just simple and conversational, but they reveal a lot.
One question I often ask is,...
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]
June 30, 2015 at 3:52 pm
You could look at:
- data compression
- dropping unused indexes
- deleting data that is no longer needed
- dropping, or truncating, temp tables that are no longer needed
- archiving old data 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]
June 30, 2015 at 3:43 pm
Question is being asked in the forum: "if mdf get full by data then how to make free space without adding disk."
Is it ok to suggest dropping tables? :-D...
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]
June 30, 2015 at 3:38 pm
Elizabeth.Block (6/30/2015)
I didn't mention that in SSAS I have 21 cube databases. Each cube database has 1 cube associated with it. I don't know if that makes a difference.
That's why...
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]
June 30, 2015 at 3:36 pm
Drop all temp tables that are no longer needed.
Close all connections that are no longer needed.
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]
June 30, 2015 at 3:33 pm
Elizabeth.Block (6/30/2015)
I tried running this on both the DB engine and the SSAS instance. The SSAS instance said The syntax for 'OPENQUERY' is incorrect.
The DB engine returned this error: Could...
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]
June 30, 2015 at 3:14 pm
Elizabeth.Block (6/30/2015)
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]
June 30, 2015 at 2:48 pm
faulknerwilliam2 (6/30/2015)
Dear AlvinThanks, your solution worked perfectly. I wish I could buy you a drink.
You're welcome. Drink sounds good right now. 🙂
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]
June 30, 2015 at 11:25 am
faulknerwilliam2 (6/30/2015)
Thanks for the very prompt response: much appreciated.Sorry to appear feeble, but could you please suggest how I would write the expression as you mention above?
If I understand your...
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]
June 30, 2015 at 9:56 am
Replace the date field(s) with another IIF to return the default date if the date is blank.
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]
June 30, 2015 at 8:08 am
rajagopalanseeth (6/29/2015)
I wanted to find the max value of a column. I have the following table structure
OrderIDTaskIDSerialNo
112
123
211
222
From the above table i want the following result for every orderID and TaskID...
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]
June 29, 2015 at 12:55 pm
jbalbo (6/29/2015)
case when (Question1 = N'No') then 'text here ' else '' end
+ case when (Question2 = N'No') then 'text here ' else...
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]
June 29, 2015 at 12:50 pm
Viewing 15 posts - 601 through 615 (of 3,666 total)