Viewing 15 posts - 11,221 through 11,235 (of 49,563 total)
Why are you trimming a float in the first place?
A float cannot have leading or trailing spaces as it's a numeric data type. Only strings can have leading or...
October 22, 2013 at 2:09 pm
spectra (10/22/2013)
one can not change database names in drop down box.....is not it ?
I'm going to guess you haven't tried and just decided to imply that I'm lying without even...
October 22, 2013 at 2:03 pm
madhu-686862 (10/22/2013)
Is there available memory for SQL to allocate?
8 GB Max Memory is configured for INS1 but it is taking only 3 GB. That means it has 5 GB...
October 22, 2013 at 1:44 pm
spectra (10/22/2013)
(2) I want to create another db (not sample) but different name i.e testing_db
Yes, you said that in the first post.
Can you please tell now how the command will...
October 22, 2013 at 1:41 pm
Open up Books online, go to RESTORE DATABASE and look at the large number of detailed explanations and examples listed there.
The MOVE clause specified where the database files should go...
October 22, 2013 at 1:04 pm
RESTORE DATABASE SomeOtherName FROM DISK = 'Sample.bak'
WITH MOVE <and specify where the files should be placed>
October 22, 2013 at 12:58 pm
Is there available memory for SQL to allocate?
October 22, 2013 at 12:57 pm
From the description, I would suspect you want an IF EXISTS construct. But really need DDL, sample data and expected results to be sure.
October 22, 2013 at 11:33 am
It's the Database!!! (10/22/2013)
Why would you put a DB on the C:\ of a clustered SQL server?
You can't even do that, a database file for a clustered SQL Server...
October 22, 2013 at 11:30 am
Keith Tate (10/22/2013)
but it has a big effect if your isolation level is set to REPEATABLE READ or SERIALIZABLE.
or SNAPSHOT
October 22, 2013 at 8:29 am
rodjkidd (10/22/2013)
Picture link of people posing in the SQL Relay shirt... Missing Friday's two victims sorry models.
Love the pic of Tony looking like he's too tired to even bother.
October 22, 2013 at 8:28 am
In the default isolation level, no effect. In other isolation levels it can change behaviour and results.
October 22, 2013 at 8:23 am
josh 92884 (10/22/2013)
CHECKDB found 0 errors and repaired 0 errors.
:sick: I didn't say run it with a repair option...
I spread this issue around to some devs on my team....
October 22, 2013 at 8:22 am
Are you sure you're posting exactly what you're trying to run?
October 22, 2013 at 7:37 am
Viewing 15 posts - 11,221 through 11,235 (of 49,563 total)