Viewing 15 posts - 151 through 165 (of 1,192 total)
JManuelN (8/4/2015)
If a restart is not possible try cleaning some buffer elements that may be using the tempdb and preventing the shrink operation. Please, let us no if it worked.
DBCC...
August 4, 2015 at 3:59 am
ben.brugman (8/4/2015)
ChrisM@Work (8/4/2015)
ScottPletcher (8/3/2015)
You can cancel the identity property by using a union or union all:
select top (0) * into #D from D1 union all select top (0) * from...
August 4, 2015 at 3:51 am
ben.brugman (8/4/2015)
Sorry this should read were the next levels up do not not exist. Top does exist but all the levels below the top do not exist (yet).
That's really really...
August 4, 2015 at 3:23 am
Toss up between 2 & 3 for the closest wrong answer... went the wrong way 🙂
August 3, 2015 at 5:53 am
So this then?
SELECT pf ,
Data ,
Descr,
ROW_NUMBER() OVER (PARTITION BY pf ORDER BY Data DESC,idAuxiliarPF DESC)
FROM dbo.PFAuxiliar PFA1
WHERE Data <= GETDATE()
AND Descr IS NOT NULL
July 30, 2015 at 11:47 am
Didn't know about this, but that's a sweet new feature!
Cheers Kapil.
July 30, 2015 at 6:48 am
Unless I'm missing something, surely your entire query is just this?
SELECT pf ,
Data ,
Descr
FROM dbo.PFAuxiliar PFA1
WHERE Data <= GETDATE()
AND Descricao IS NOT NULL
July 30, 2015 at 6:41 am
What's the size of the Decsr field? NVARCHAR(??) At a guess it's MAX & the difference is because you're returning significantly more data.
When you say partition to join with another...
July 28, 2015 at 11:11 am
45% of 200MB = 90MB, is it really worth worrying about?
Most processes that use tempdb won't be running in the context of tempdb so querying sysprocesses where dbid = 2...
July 27, 2015 at 7:51 am
Ah, I've a hankering to read The Elenium/Tamuli again (4th time!) but gave them away some time ago 🙁
My bookshelf's mainly Banks & Stephenson now, with a sprinkling of Gaiman.
I've...
June 26, 2015 at 5:49 am
My guess here would be the report's fine, just returning no data. As others have said, see if you can run the query in SSMS as yourself and the report...
June 5, 2015 at 9:54 am
comeraghsolutions (6/5/2015)
So my question is could I make use of this relatively large transaction file and start deleting transactions without out actually adding to the transaction file size.
Yep, if you...
June 5, 2015 at 9:35 am
If you're using Exchange, check with your Exchange admin that the sending account has the necessary permissions and/or that SMTP settings (port, authentication & user credentials) are correctly set.
June 5, 2015 at 9:21 am
Jack Corbett (5/22/2015)
We do have white noise generators
Huh?
May 22, 2015 at 9:21 am
Assuming they're not FILESTREAM then, they're really not part of the database at all.
Perhaps they should be backed up to tape directly via the array. More in line with how...
May 13, 2015 at 11:02 am
Viewing 15 posts - 151 through 165 (of 1,192 total)