Viewing 15 posts - 1 through 15 (of 27 total)
GROUP BY 😀 look it up
Select columns , count(column) from tb
where something
group by columns
-- optional having clause to filter
June 15, 2011 at 12:18 am
I wonder if you should just partition the huge tables with index aligned to the partitions and using a high fill factor and then just forget about it.
If your worried...
June 15, 2011 at 12:08 am
http://technet.microsoft.com/en-us/library/ms189628.aspx
the buffer manager per counter should help you decide if you want to go ahead with compression.
Page reads/sec
http://www.sql-server-performance.com/2005/monitor-io-counters/
For small db sizes the trade off time...
June 14, 2011 at 7:10 am
ur right that the trace should contain details of the database being dropped.
However since your trace log files do not show the details i cant explain y ?
Since...
June 14, 2011 at 7:02 am
ignore my last , i didnt see the joins
June 14, 2011 at 3:07 am
You can try changing the db owner , else if your too worried you might do damage , try disabling the login.
June 14, 2011 at 2:59 am
As mentioned already Defrag over shrink db 😀 however i can think of one place where a shrink db could be a good idea. Again this might not be...
June 14, 2011 at 2:56 am
try select * from sys,sysfiles under the db your missing , if you think its in a different loaction. Else if u cant the see the file , the db...
June 14, 2011 at 2:47 am
If the database is showing up when u query sys.databases its not dettached. But you can still try.
Try to see if the database is available by querying for objects in...
June 14, 2011 at 2:44 am
Are u using nvarchar as the datatype of the column your returning ?
Also verify the collation of the columns
additonally when querying data operatoe = on a nvarchar column
the...
June 13, 2011 at 7:05 am
Since you performing two different types of activities here you might want to consider the following.
The report needs to be real time ? then you answer is Replication ,...
June 13, 2011 at 12:54 am
Not sure if this is what your looking for but gave it a try anyway. Since your just looking to get a set of lookup values and then fetch the...
June 13, 2011 at 12:46 am
Money data type can store upto .0001 in terms of monetary value. However this might not work especially for cases where the currency is so devalued that it takes more...
June 13, 2011 at 12:22 am
Out of curiosity ,would there be a performance impact on sql trying to get the underlying definition for the table , things like datatype , collation etc. vs defining it...
June 10, 2011 at 1:47 pm
Viewing 15 posts - 1 through 15 (of 27 total)