one of the core caveats of the development life cycle is that  the code is tested in dev, and is promoted UNCHANGED to the next layer for acceptance and testing.

if...

you can check teh procedure cache.

if you run this, you might see the same procedure multiple times, because each has a specific execution plan due to different parameters:

            
October 21, 2019 at 1:13 pm
            
#3690562

            
            
                                                
        

does the machine in question have more than one instance installed? could you have updated just one of the multiple instances on that machine to SP4 instead of all of...

generating the schema scripts for tables/views/procs is easy in SSMS, but don't script the data. 60 gig of data is unmanageable as flat files, you want to use The import...

it is not possible to restore a SQL database from a higher version to a lower version.

you can only restore from lower to higher versions.

you will have to use something...

I think you want to convert the date to varchar, and if the results is NULL, use the string NULL

ISNULL(convert(varchar(20),@Date,GETDATE()),110),'NULL')

by queries, i am guessing you mean tables, instead.

you can sue the metadata to script out the actual queries by getting the column names, is that what you are after?...

have you set your max server memory to a low threshold, so it ends up clearing the procedure cache?

in my experience, most performance problems come from coding that works, but performs poorly on large data sets.

as a result, i look at the code, here are some of the...

• This reply was modified 6 years ago by Lowell. Reason: added FOR XML hint

ok the forum converts to varchar as  well! so my  nvarchar string characters got converted to question marks!

your query did not appear, but i suspect it has to do with implicit conversions.

you have to use the N'' denotation to make sure SQL knows it is nvarchar data.

here...

are you using a sliding partition strategy for archiving?

don't look at the file groups. file groups is how it is stored, and potentially archived. that is independent from the logical...

when the job fails.

if you change it to when the job completes, you gent both success and failure emails.

a simple basic example of cross applying a datamath function to get your 36 values based on one date.your example did not go by date, it seemed, though; are you...

Roland are you creating the SPN's manually?

typically, the service account running the SQL service creates the SPN on restart of the SQL service.

That means it needs the Trusted for Delegation...