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...
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...
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?
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,...
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...
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...
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...
June 30, 2015 at 3:36 pm
Drop all temp tables that are no longer needed.
Close all connections that are no longer needed.
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...
June 30, 2015 at 3:14 pm
Elizabeth.Block (6/30/2015)
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. 🙂
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...
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.
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...
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...
June 29, 2015 at 12:50 pm
Viewing 15 posts - 601 through 615 (of 3,666 total)