Viewing 15 posts - 11,221 through 11,235 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2013 at 2:09 pm
dup
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2013 at 2:04 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2013 at 1:04 pm
RESTORE DATABASE SomeOtherName FROM DISK = 'Sample.bak'
WITH MOVE <and specify where the files should be placed>
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2013 at 12:58 pm
Is there available memory for SQL to allocate?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2013 at 8:28 am
In the default isolation level, no effect. In other isolation levels it can change behaviour and results.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2013 at 8:22 am
Are you sure you're posting exactly what you're trying to run?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2013 at 7:37 am
Viewing 15 posts - 11,221 through 11,235 (of 49,552 total)