Viewing 15 posts - 16,396 through 16,410 (of 59,067 total)
Timmorehead 14652 (11/2/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 3, 2016 at 6:52 am
David Burrows (10/31/2016)
Jeff Moden (10/31/2016)
Pictures are good but they're tough to execute. If you'd like a coded answer, please see the first link in my signature line below.
😀
IF OBJECT_ID('TempDB..#testtable','U')...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 9:20 pm
Super_Grover (11/2/2016)
Jeff Moden (11/2/2016)
Super_Grover (11/2/2016)
This is the largest table in the whole DB. [font="Arial Black"]The whole DB needs to be transferred.[/font]
The solution is pretty easy then. Don't try to...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 1:18 pm
With "Instant File Initialization", there just isn't a need to do any type of "manual" or "scheduled" growth.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 12:51 pm
Eric M Russell (11/2/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 12:47 pm
As Granny used to say... "Figures can lie and liars figure". 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 11:26 am
hoseam (11/2/2016)
I need to return AuditDate, Date of AuditDate and Time of Audit Date. I will then be linking these to my date_time Dimension.
As Jason suggests, I'd spend some time...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 8:43 am
GA_SQL (11/2/2016)
need a script or an idea to create script when my db is full by 75% i want add some space to the db
This could actually be a very...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 8:34 am
Super_Grover (11/2/2016)
This is the largest table in the whole DB. [font="Arial Black"]The whole DB needs to be transferred.[/font]
The solution is pretty easy then. Don't try to write a home-grown...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 8:24 am
Not only will you get a huge number of false positives, as Sean stated, but it's mostly going to be useless even if you could make it work perfectly because...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 8:17 am
snomadj (11/2/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 8:01 am
Deny Christian (11/1/2016)
i used this syntax
DECLARE @CMD sysname
--create .bat:
/*.bat:
@echo off
forfiles /p "d:\backup\bck_denyc\combine" /m *.bak /c "cmd /c del /Q @file" /d -30 --to delete 30 days back
@echo off
*/
--execute the...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 7:55 am
hoseam (11/2/2016)
declare @t datetime = '2016-11-02 07:22:26.320'
SELECT LEFT(CAST(REPLACE(CONVERT(VARCHAR, @t, 108), ':', '') AS INT), 6)
which gives me INT value of 72226, and I want it to include the...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 2, 2016 at 7:15 am
Wow... That's just silly how well that works! And I've tried a couple of different methods to beat it and haven't been able to even in the SIMPLE Recovery...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2016 at 8:55 pm
To be honest, this sounds like an interview question. Try the following search and see for yourself.
[font="Arial Black"]http://bfy.tw/8Vtu[/font]
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2016 at 5:28 pm
Viewing 15 posts - 16,396 through 16,410 (of 59,067 total)