Viewing 15 posts - 136 through 150 (of 157 total)
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
@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...
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...
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...
November 29, 2016 at 5:02 am
Who do you blame for the lack of snow, Obama or Trump :hehe:?
PS: Happy holiday.
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...
September 17, 2016 at 2:10 am
Indianrock (9/16/2016)
September 16, 2016 at 8:41 am
BULK INSERT? Or are you lamenting the absence of BULK EXPORT?
I'm missing BULK EXPORT.
Another point: even if you can do some OS-like stuff with SQL Server, the account that runs...
September 16, 2016 at 12:40 am
I think the risk is reasonable, as long you are using an xp_cmdshell_proxy_account with minimal privileges.
On the other side it would nice, if SQL Server would provide us with more...
September 16, 2016 at 12:22 am
If he would have written a book, than he would have written it on a PC with Word or on a typewriter (if he is conservative).
I don't believe that even...
September 5, 2016 at 1:11 am
~95 km; Bonn (Germany); once a year (in June)
July 29, 2016 at 11:01 am
Viewing 15 posts - 136 through 150 (of 157 total)