Viewing 15 posts - 2,296 through 2,310 (of 6,038 total)
The Dixie Flatline (9/8/2016)
I agree with Chris and Gail.Every one of those emails are going to result in a "WHY DID THEY KILL MY JOB?" scream.
That's why...
September 9, 2016 at 7:14 am
I'm not sure if this approach would be flexible enough for your needs, but it would leverage some built in features of SQL Server, rather than attempting to code your...
September 8, 2016 at 8:51 am
Maybe somtimes veteran forum members make invalid assumptions about the technical expertise of new members, so called "grasshoppers", who quite possible know more in actuality than any of the regulars....
September 8, 2016 at 8:03 am
kweiskittel (9/6/2016)
It's the same SQL account; one user can see the tables, the...
September 8, 2016 at 7:40 am
Gary Varga (9/8/2016)
Eric M Russell (9/8/2016)
September 8, 2016 at 7:17 am
Welsh Corgi (3/23/2012)
Until today I never saw a Database that contained both the Staging Tables and Data Warehouse Tables in the same Database....
Until SQL Server 2012, it wasn't an option...
September 8, 2016 at 7:12 am
I don't know who came up with the idea of adding an 'Edit' button to this forum, but they were spot on. We probably wouldn't still be here is it...
September 8, 2016 at 6:58 am
coool_sweet (8/28/2016)
i am not finding it anywhereyes interview question
The following website can be used to locate Nolocks in the US.
I'm seeing several in Colorado, Wisconsin, New Jersey, and Michigan.
Regards
September 7, 2016 at 12:06 pm
ebooklub (9/7/2016)
Recruiters agree on asking rate, applications was submitted, few days later recruiters responded that clients looking for intermediate...
September 7, 2016 at 10:10 am
Some organizations think that a DBA is some dude who sits in a closet full of servers, shuffling tape backups and eating potato chips. That's what they pay for, and...
September 7, 2016 at 7:37 am
Tell your DBA that she get's the job done, but she's kind of clunky when it comes to offering constructive advice about T-SQL.
September 7, 2016 at 7:27 am
Jason A. Long (9/6/2016)
Eric M Russell (9/6/2016)
J Livingston SQL (9/6/2016)
-- just for fun
SELECT[dbo].[DoubleMetaPhone]('Pheasant');
SELECT[dbo].[DoubleMetaPhone]('Phesant');
SELECT[dbo].[DoubleMetaPhone]('Fessant');
SELECT[dbo].[DoubleMetaPhone]('Fezant');
SELECT[dbo].[DoubleMetaPhone]('Phes ant');
SELECT[dbo].[DoubleMetaPhone]('Fez aunt');
quite impressive
Still there is the issue that two words sounding alike are completely different.
SELECT[dbo].[DoubleMetaPhone]('Pheasant');
FSNT FSNT
SELECT[dbo].[DoubleMetaPhone]('Fussy Aunt');
FSNT...
September 6, 2016 at 2:40 pm
If you've enabled login auditing, and you've confirmed no logins for past month, then should do it. At this point disable them and have an email alert notify you in...
September 6, 2016 at 2:25 pm
J Livingston SQL (9/6/2016)
-- just for fun
SELECT[dbo].[DoubleMetaPhone]('Pheasant');
SELECT[dbo].[DoubleMetaPhone]('Phesant');
SELECT[dbo].[DoubleMetaPhone]('Fessant');
SELECT[dbo].[DoubleMetaPhone]('Fezant');
SELECT[dbo].[DoubleMetaPhone]('Phes ant');
SELECT[dbo].[DoubleMetaPhone]('Fez aunt');
quite impressive
Still there is the issue that two words sounding alike are completely different.
SELECT[dbo].[DoubleMetaPhone]('Pheasant');
FSNT FSNT
SELECT[dbo].[DoubleMetaPhone]('Fussy Aunt');
FSNT FSNT
September 6, 2016 at 11:33 am
By default, VIEW DEFINITION (access to DDL text of an object) is denied. You can grant this a user at the server, database, schema, or object level. The following article...
September 6, 2016 at 11:23 am
Viewing 15 posts - 2,296 through 2,310 (of 6,038 total)