Viewing 15 posts - 31 through 45 (of 119 total)
Thanks,
Actually I am new to it and haven't used this tool.
I will test it.
October 2, 2013 at 10:29 am
greg.bull (9/24/2013)
3) How could it be being blocked, I wonder ?
If you have FK keys referencing this table then there are chances that you can experience blocking.
what is the value...
September 25, 2013 at 5:28 am
It depends on the setup.
I would prefer to put the datafiles on separate drives.If i have 4 data files then 2 datafiles on one drive and 2 on other.
You need...
September 25, 2013 at 4:27 am
Fishbarnriots (9/25/2013)
The backup file is then copied to Server B and restored.
hopefully you have restored all the required files including log files 😉
September 25, 2013 at 2:33 am
ksatpute123 (9/24/2013)
I had to think about it for a while before answering. Good one.
same here.Thanks Smith
September 24, 2013 at 1:53 am
on thing you can try out
insert new Image tooltip.
If new Image tool tip works fine then you need to tally the properties of new Image tooltips and Old Image tooltips.
September 24, 2013 at 1:48 am
use breakpoints to debug connection settings
September 21, 2013 at 4:41 am
Sean Pearce (9/20/2013)
The ISNUMERIC function tells you if you have a valid int, numeric or float. 8E10 is a valid float.
declare @varchar varchar(50)select @varchar = '8E10'
select @varchar
select isnumeric(@varchar)
select convert(float, @varchar)
go
thanks...
September 20, 2013 at 6:25 am
user defined functions in sql server doesn't allow you to perform ddl/dml operations on permanent tables
September 20, 2013 at 5:14 am
I didn't say that shrink work only on log file ,it can work on both.
but none is advisable until necessary.
back to your question:
you can use dmvs to find missing,unused indexes
you...
September 20, 2013 at 4:55 am
Shrink release the unused space from the databases.
There could be multiple reasons your report is running slow.
Either improper/bad/missing index,
bad queries.
to reclaim the space first check the db log size and...
September 20, 2013 at 4:39 am
Jeff Moden (9/16/2013)
psingla (9/16/2013)
http://pramodsingla.wordpress.com/category/interview-questions-2/%5B/quote%5D
siggemannen (9/16/2013)
Or SELECT 'me' if you're a bit on the joking side...
Or:
SELECT MAX(salary)
FROM t
WHERE salary < (SELECT MAX(salary)...
September 16, 2013 at 8:01 am
Viewing 15 posts - 31 through 45 (of 119 total)