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...

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...

Grant Fritchey (11/29/2016)

---

joeroshan (11/29/2016)

---

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...

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...

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]),...

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...

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 ?

SELECT DEST.[text] ,

Substring(DEST.TEXT, (r.statement_start_offset / 2) + 1, ( ( CASE r.statement_end_offset WHEN - 1 THEN

Datalength(DEST.TEXT) ...

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...

mw112009 (9/28/2016)

---

The following SQL works fine. Gets a list of views, sps and functions in the DB.

However I would like the rows to land in a certain order.

Lets say a...

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...

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...

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...

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...

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...