Viewing 15 posts - 166 through 180 (of 192 total)
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'. God is real, unless declared integer.
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...
God is real, unless declared integer.
February 8, 2017 at 12:46 am
God is real, unless declared integer.
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...
God is real, unless declared integer.
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
God is real, unless declared integer.
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...
God is real, unless declared integer.
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...
God is real, unless declared integer.
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,...
God is real, unless declared integer.
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...
God is real, unless declared integer.
December 2, 2016 at 3:26 am
@steve-2: What would you do regarding the column order, when you are facing a CREATE OR ALTER <table> statement and the column order differs from the real. Recreating could be...
God is real, unless declared integer.
November 29, 2016 at 8:26 am
djackson 22568 (11/29/2016)
I never have an issue with this. A simple "if exists" tells me if I need to delete something before running create.
Yes, and doing this you drop...
God is real, unless declared integer.
November 29, 2016 at 8:16 am
I doubt, that an ALTER OR CREATE <table> would be used commonly, particularly since a CREATE table will usually need some indexes, FKs, CHECK CONSTRAINTs and some other stuff too.
Furthermore...
God is real, unless declared integer.
November 29, 2016 at 5:02 am
Who do you blame for the lack of snow, Obama or Trump :hehe:?
PS: Happy holiday.
God is real, unless declared integer.
November 24, 2016 at 12:48 am
van.yancey (9/16/2016)
I've only used it on Azure SQL Datawarehouse, but I believe the Polybase feature in SQL Server 2016 solves the problem of BULK EXPORT.
But it would be a little...
God is real, unless declared integer.
September 17, 2016 at 2:10 am
Indianrock (9/16/2016)
God is real, unless declared integer.
September 16, 2016 at 8:41 am
Viewing 15 posts - 166 through 180 (of 192 total)