Viewing 15 posts - 211 through 225 (of 476 total)
tshad (9/28/2015)
in the same order as in the query.
Order is not important. I would recommend that you change the call to your SProc from:
EXEC R01OrderForm @Region, @District, ...
to
EXEC R01OrderForm...
September 29, 2015 at 4:24 am
robinwilson (9/28/2015)
I exported all functions and stored procedures and ran a find and replace forOLD SERVER > NEW SERVER
CREATE FUNCTION > ALTER FUNCTION
CREATE PROCEDURE > ALTER PROCEDURE
In case it...
September 29, 2015 at 2:16 am
robinwilson (9/28/2015)
1. Create a new function using SQL
2. Rename the function using right-click in SSMS
3. Run sp_HelpText [FUNCTION]
4. The output should...
September 29, 2015 at 2:14 am
robinwilson (9/28/2015)
VirtualisationThe server is virtualised on a VMWare host and I do wonder if something is wrong there
I don't know anything about the hardware side ... but we have had...
September 29, 2015 at 2:03 am
I've never tried mirroring / log shipping in this scenario, always done it "manually".
For us this pretty much only occurs when we upgrade both hardware and SQL version. Can...
September 29, 2015 at 1:50 am
In these situations I adopt what I consider to be a Defensive Programming stance. Of course we can all argue that Black-is-White on this situation 🙂 It...
September 29, 2015 at 1:44 am
Alvin Ramard (9/28/2015)
WHERE YourDateColumn >= @StartDate
AND YourDateColumn < @DayAfterEndDate
and not:
WHERE YourDateColumn >= @StartDate
...
September 28, 2015 at 9:36 am
Jeff Moden (9/28/2015)
+1000
My new high score :w00t:
FWIW a +1000 pet-hate of mine is using short mnemonics for the datepart parameters e.g. DATEADD(dd, ... instead of DATEADD(Day, ...
I have no idea,...
September 28, 2015 at 9:16 am
Typical! The one datatype I didn't think to try, thanks for that.
Makes much more sense now that I have learnt that ISNUMERIC returns true if value can be converted to...
September 28, 2015 at 2:16 am
smer (9/28/2015)
Help to get the Sql Query e.g when execute on 8/15/2015 get the records from 8/1/2015 to 8/15/2015, if run on 9/20/2015 get the results...
September 28, 2015 at 2:08 am
September 28, 2015 at 12:41 am
Copy time is usually the, relatively, slow part for us so we don't detach / copy / re-attach
Assuming database is in Full Recovery Model then we take Full backup (or...
September 28, 2015 at 12:37 am
David.Poole (9/27/2015)
they tend to present their requirements in terms of solutions to the symptoms rather than the actual problem they are trying to fix
Very true 🙂 If I had...
September 27, 2015 at 6:38 am
Just in case useful:
-- Oldest backup record in MSDB
SELECTMIN(backup_start_date)
FROMmsdb.dbo.backupset
September 27, 2015 at 4:43 am
Glad you have found the cause. Maybe add some, daily, FileSize Logging so you can see growth-over-time 😉 Even 3GB sounds quite generous to me for MSDB MDB but, as...
September 27, 2015 at 4:41 am
Viewing 15 posts - 211 through 225 (of 476 total)