Viewing 15 posts - 91 through 105 (of 122 total)
oh, thanks (I usually use only the deep links in the newsletters and visit the SSC start page only very seldom ...
April 5, 2017 at 1:30 am
Why do you not use a much more short and simple
DECLARE @bd DATE = '19801231', @TD DATE = '20171231'
SELECT DATEDIFF(YEAR,
March 28, 2017 at 3:58 am
beside the "default" (at least before SQL 2016) Trace Flags 1117 / 1118 (Grow all Files in a FileGroup equally / prevent mixted extends) I'm using:
1222 (allows Deadlock monitoring),...
March 17, 2017 at 1:44 am
March 8, 2017 at 8:07 am
March 8, 2017 at 7:28 am
Nice to know, how to install / configure it, but I still do not know, if and how this will work, when a server crash and has to fail over...
March 8, 2017 at 1:24 am
Your code, where you select for definition like '%' + @ValueToFind + '%' is wrong, since it would return references to MyDB10 and MyDB1_test and dev_MyDB10 when @ValueToFind is 'MyDB1'.
March 6, 2017 at 2:25 am
This is not true.
I just usedDBCC SHRINKFILE (N'mydb_log' , 0, TRUNCATEONLY)
on my 4 GB log file and it is now down to 10 MB (10...
February 8, 2017 at 12:46 am
January 27, 2017 at 6:26 am
I would have opened the Windows drive management console and changed the drive letter from t: to something else and added t: as additional letter to the d:-drive... (+ maybe...
January 26, 2017 at 2:01 am
t.franz - Sunday, January 15, 2017 8:06 AMComments posted to this topic are about the item DECLARE multiple vars with default value
January 16, 2017 at 1:12 am
Would it be possible to install my real instance e.g. at myserver port 9999 and a second instance with empty databases uses the same name at port 1433 that links...
January 13, 2017 at 1:00 am
Where do you need RegEx? LIKE is supporting it currently, so the only other point could be something like REPLACE (but I never needed it for REPLACE).
They already added some...
December 27, 2016 at 8:01 am
Regarding the OPTION RECOMPILE:
It would help only, when you change your WHERE to something as
WHERE (ISNULL(@ForumName, '') <> '' AND tbo.ForumName LIKE @ForumName + '%')
OR (ISNULL(@SurName,...
December 2, 2016 at 3:54 am
A drawback of having the Jobs in the database would be, that - when you restore the database as _test, _dev or whatever, those jobs would be started and this...
December 2, 2016 at 3:26 am
Viewing 15 posts - 91 through 105 (of 122 total)