Viewing 15 posts - 2,326 through 2,340 (of 49,552 total)
I strongly recommend you move the login auditing to SQLAudit or Extended Events rather.
They're far more suitable for this kind of audit, and doing so means that your error...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2016 at 7:04 am
mcfarlandparkway (9/26/2016)
Now i want to use this function in my stored procedure to get code and lcode values?
With the really vague question and lack of details, hard to say anything...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 27, 2016 at 1:31 am
Err, what do you mean by 'select statement of the stored procedure'?
I assume this is a table-valued UDF. If so, then it's used in the FROM clause of a select
SELECT...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2016 at 2:03 pm
With login success being logged to the error log, you don't, not without a nasty amount of text processing. It's one of the more useless settings I've seen, makes the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2016 at 1:58 pm
Create a job that runs at the start of a year or database trigger on create table that regenerates the view with the tables that do exist. Dynamic SQL to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2016 at 1:48 pm
call.copse (9/26/2016)
"If you really can't fix the problem then,"Can't fix the problem? Does this situation really occur? Everything is fixable one way or another...
Yes, it happens. I've had a couple...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2016 at 11:08 am
Yanum_Vlad (9/25/2016)
I still do not catch, how Full (!) log backup works when Bulk Minimal logging is in place.
BOL states:
Under the bulk-logged recovery model, if a log backup covers...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2016 at 12:58 pm
Good, now maybe ask your boss about sending you on a basic T-SQL course, if you're going to be working with database code a lot.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 24, 2016 at 5:31 am
If everything's going to the same SAN array, then you only separate for easier space management, so that a runaway TempDB won't also make the user DBs run out of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2016 at 9:49 am
No, you can't change the definition of the system views.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2016 at 9:13 am
Mike Scalise (9/23/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2016 at 9:05 am
Eirikur Eiriksson (9/23/2016)
the @with additional parameters should be all in one line, something along this line:
@with = 'replace ,move "Logicalfilename" to "F:\Data\TestDB.mdf" ,move LogicalFilenameofLog" to "F:\Logs\TestDB.ldf"'
Restore is whitespace agnostic, the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2016 at 8:25 am
I strongly recommend you remove that file, as you are very likely in violation of the UK data privacy laws by posting personally identifying data in public.
Post made up data...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2016 at 6:38 am
ScottPletcher (9/22/2016)
Also, be aware that some plans are never cached at all, for example, a trivial plan to satisfy "select * from table_name".
Trivial plans have been cached since SQL 2005....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2016 at 12:51 pm
lmk1 (9/22/2016)
I have it set to PRINT in the example code for testing purposes, but eventually I don't want to print, I want to drop.
The PRINT is just so you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2016 at 12:50 pm
Viewing 15 posts - 2,326 through 2,340 (of 49,552 total)