Viewing 15 posts - 46 through 60 (of 405 total)
Upgrade the instance if possible. A everyone suggested you can upgrade the database and cannot downgrade it back. Compatibility mode does not have any effect in this scenario. The first...
November 29, 2016 at 9:29 am
Yes. The data files need to be of same size if you need proportional fill algorithm to work. You can validate the file usage using following query
Select Name,type_desc,physical_name,size*8.0/1024 SizeMB,(size-FILEPROPERTY(name,'Spaceused')) *8.0/1024.00...
November 29, 2016 at 8:12 am
Grant Fritchey (11/29/2016)
joeroshan (11/29/2016)
November 29, 2016 at 7:19 am
By 'select in select' do you mean sub queries? In that case it is better to use joins that sub queries. You may not be noticing any difference currently due...
November 29, 2016 at 3:45 am
Hi
I found the below query from performance dashboard tool. You can try using that
declare @ms_now bigint
select @ms_now = ms_ticks from sys.dm_os_sys_info;
select top 50 record_id,
dateadd(ms, -1 * (@ms_now - [timestamp]),...
November 29, 2016 at 3:33 am
I am not aware of any such restrictions. I quickly tried with a named instance and it worked for me.
However can you try creating an alias and use...
November 23, 2016 at 7:57 am
Hi
If you are getting login failed error then it already has established connection and it fails at authorisation.
Are you able to connect through SSMS or sqlcmd ?
November 23, 2016 at 6:26 am
SELECT DEST.[text] ,
Substring(DEST.TEXT, (r.statement_start_offset / 2) + 1, ( ( CASE r.statement_end_offset WHEN - 1 THEN
Datalength(DEST.TEXT) ...
November 23, 2016 at 6:19 am
Being myself worked as both DBA and developer, I have interacted with the other for both sides. Each camp, people who are ready to learn and grow, makes work always...
October 5, 2016 at 6:44 am
mw112009 (9/28/2016)
However I would like the rows to land in a certain order.
Lets say a...
September 28, 2016 at 10:24 am
I just did a quick check myself, running the query (Of course id do not have table) and strangely found a sleeping session with open transaction.
I ran the following...
September 28, 2016 at 8:10 am
With Appt
as
(
Select F.MRN,N.ApptDt as NoShowDate,F.ApptDt as NextApp,ROW_NUMBER() over (Partition by F.MRN order by F.ApptDt ) Rnm from #NoShow N join #FutureAppts F on N.MRN=F.MRN
and F.ApptDt>N.ApptDt
) select * from Appt...
September 22, 2016 at 9:58 am
As Kevin and Gail already said, before you go to the effort first we need to find out the why these things are considered together for same problem.
These are few...
September 22, 2016 at 8:30 am
Thanks a lot for the detailed explanation Jeff. Looks like I need to play around with some flat files this weekend. Hope the waxb18 still watching the thread and would...
September 22, 2016 at 8:17 am
Your print statement generates PRINT Company\user, should probably be PRINT 'Company\user'
Try 'PRINT ''' +@NextUser+''';',
As Gail mentioned testing with print or select before Exec would help you fix...
September 22, 2016 at 8:01 am
Viewing 15 posts - 46 through 60 (of 405 total)