Viewing 15 posts - 151 through 165 (of 283 total)
Grant Fritchey
Fine, but where is it coming from? It's not a part of the query as outlined, so is that thing that appears to be a table a view...
March 13, 2014 at 10:27 pm
Hi,GilaMonster
Due business reasons i am unable to give u the entire table definitions
Table_one having 2 uniqueidentifier(one key is generated in the table by using DEFAULT newid()) , 6...
March 13, 2014 at 10:21 pm
Yes Col4 is having condition as (Col4>0 OR COL4 =200000000)
March 13, 2014 at 8:06 am
have attached SETSTATISTICSPROFILE ON
can u peoples help on urgent basis
March 13, 2014 at 7:37 am
The index rebuild is running out of space in whatever DB and file were indicated in the error message. Grow the file or add more disk space as appropriate.
I was...
March 12, 2014 at 5:42 am
twin.devil (3/12/2014)
yuvipoy (3/12/2014)
200 GB for each drivehow much empty space u have ?
yuvipoy (3/12/2014)
March 12, 2014 at 5:37 am
I have already issued DBCC updateUsage and as well SP_spaceused with 'true'
Maxsize in size file is also set as -1 only in sysfiles
March 12, 2014 at 4:38 am
I am having the disk size of near 200 GB only 10 GB is filled till date.
Just now i ran dbcc reindex
getting same error msg as Msg 1105, level7, state...
March 12, 2014 at 3:50 am
There are enough space is there .
The db has been set to auto grow only.
only thing is database is set as Simple mode is this a problem ?
If i switch...
March 12, 2014 at 2:47 am
GilaMonster (3/11/2014)
yuvipoy (3/11/2014)
I am just asking will there be inprovement if there the data type is IntImprovement over what?
Improvement over Float.
March 11, 2014 at 7:32 am
GilaMonster (3/11/2014)
If not, then design your database according to good data design principals (including picking the correct data type for the...
March 11, 2014 at 7:05 am
GilaMonster (3/11/2014)
GUID ordering is not alphanumeric. There's articles on the web which describe how GUIDs are ordered, not that it usually matters much for users.
Then why the column can not...
March 11, 2014 at 5:07 am
At present one of my column is having uniqueidentifier with clustered, unique, primary key located on PRIMARY
The data is inserted in the below manner
66B72949-658B-4D77-A813-01AC3278AD53
066C863E-1A14-4F0C-A4E6-053D02F98CB8
63C1E1C9-FABF-444E-AE01-0752A8C9A7DD
AE6CCB63-1764-42C6-A7E2-08F04A2CA4DB
F2D58665-301B-467F-B0A4-08F46A4B71A3
7CC0A364-C455-4FD0-A4F8-0951693312C0
Why it is not in logical...
March 11, 2014 at 4:18 am
Viewing 15 posts - 151 through 165 (of 283 total)