Viewing 15 posts - 1,441 through 1,455 (of 6,036 total)
J Livingston SQL (5/8/2016)
ok.The original code was found on the web http://www.nigelrivett.net/SQLTriggers/AuditTrailTrigger.html
can you please provide sample to code to explain what you mean?
Many thanks
Sorry, did not have much time to...
May 9, 2016 at 12:37 am
J Livingston SQL (5/6/2016)
R.P.Rozema (5/6/2016)
mock up some example table and generate a significant volume of test data into itsome test data......and yeah the generic audit is slow.
It's only slow...
May 8, 2016 at 8:19 am
Jez-448386 (5/5/2016)
May 5, 2016 at 9:29 pm
Create a calendar table having a record for each day you company has been or will be filing tax reports.
Not sure if it's good or bad, but there are not...
May 5, 2016 at 6:52 pm
We might be using different Googles.
Because mine one has very little presence of SharePoint in relation to RBS.
First of all, it tells me that:
"Remote Blob Storage (RBS) is a library...
May 4, 2016 at 11:18 pm
To avoid problems with temp tables caused by server collation i always script them like this:
CREATE TABLE #tbl(
col1 varchar(10) COLLATE DATABASE_DEFAULT
);
May 4, 2016 at 9:44 pm
yaakov.kravitz (5/4/2016)
As workaround, I set the value to null and it yielded an empty string ('') in the text file. Any other way without forcing it to null value?
Not quite...
May 4, 2016 at 8:47 pm
I think you're overcomplicating the matter.
There must be already some software which creates and/or saves the sound files in the file storage.
Without it there would not be .wav files.
So, your...
May 4, 2016 at 5:41 pm
Rod at work (5/4/2016)
We're going to use C#, probably in the front-end application, to do the auditing.
Start studying latest advances in hardware.
They usually do not admit wrong decisions easily, so...
May 4, 2016 at 9:17 am
Studio has an XML Parser built in it.
This module is responsible for reading, validating and formatting XML strings when you open it for viewing.
It's a front-end application, not any part...
May 4, 2016 at 5:00 am
Are you sure the XML's stored in the table contain line breaks?
May 3, 2016 at 11:04 pm
shivang.rdesai (5/3/2016)
FROM (([FactSales]
inner join [Date]
on [FactSales].DateKey = [Date].DateKey)
inner join [Product] on [Sales].ProductKey = [Product].ProductKey
inner join [ProductCategory] on [Product].ProductCategoryKey = [ProductCategory].ProductCategoryKey)
inner join [Store] on [Sales].StoreKey = [Store].StoreKey)
where FullDate =...
May 3, 2016 at 11:01 pm
SELECT date, YEAR(DATEADD(mm, 4, c.Date))%100 FY
FROM dbo.calendar c
WHERE YEAR(DATEADD(mm, 4, c.Date))%100 = 17
May 3, 2016 at 10:53 pm
Jeff Moden (5/3/2016)
Except for the occasional hard-disk problem, performance problems usually exist (there are always exceptions to every rule) in the code.
Strongly disagree! 🙂
Unless your meaning of "code" includes...
May 3, 2016 at 7:29 pm
DECLARE @HistoryDate DATETIME
SET @HistoryDate = dateadd(hour,-5, DATEADD(dd, 0, DATEDIFF(dd, 0, getdate() )) )
May 3, 2016 at 5:11 pm
Viewing 15 posts - 1,441 through 1,455 (of 6,036 total)