Viewing 15 posts - 8,296 through 8,310 (of 59,078 total)
Do you actually have 65GB remaining on the drive to create the file? And, I've got to ask, are you sure the path is correct?
November 22, 2019 at 12:46 pm
Yes, or WHERE CAST(CLOG.RecvdDate AS date) = '20191120'. I think casting as date preserves sargability (provided that the column is datetime in the first place).
John
It does and it's better...
November 22, 2019 at 12:33 pm
Have you considered just rebuilding the heap? You should also rebuild any non-clustered indexes, as well, to recover space and rebuild stats.
November 22, 2019 at 4:02 am
if all 4 columns data exists already and the new data matched with exisitng it shoudl delete using trigger.
There's a little bit of ambiguity in that statement. Delete from...
November 22, 2019 at 3:39 am
It would be nice if you provided the CREATE TABLE statment to go along with the test data. Posting the code for your attempt would probably help, as well.,
November 22, 2019 at 3:33 am
Never, never use that highly proprietary and totally nonrelational SQL_variant data type.
You really need to come out of your shell on SQL, Joe. While I agree that the...
November 22, 2019 at 3:23 am
Indirectly, yes there is, and it's a guaranteed locking approach, since it's provided by the db engine itself, and uses its own locking mechanisms internally.
Use system procs sys.sp_getapplock and...
November 22, 2019 at 2:18 am
All of that is fine but... how do you make money? You could achieve a huge number of trips per hour (your definition of "productivity" above) and not make a...
November 21, 2019 at 1:38 am
Ah... now I see where you're coming from, George. In that vein, I have to agree.
November 21, 2019 at 1:10 am
On top of everything Drew posted, you need to change the "#' signs to single quotes and, depending on the datatype for the Time column, you might not be able...
November 20, 2019 at 6:38 pm
While I agree that Access has some connection limitations, I wouldn't by any means say that it's "a one file solution, designed for a single user with a desktop". I'm...
November 20, 2019 at 6:26 pm
Great, works like a charm!
Thank you Jeffrey and Jeff.
FWIW:
IF EXISTS keeps returning an error (SS 2008 R2),
DROP SYNONYM sBewoners, does not.
Swapping the view Clients (I prefer to distinguish names...
November 20, 2019 at 2:33 pm
I have to ask... what are you pasting the code from?
Jeff, I copied it from SQL studio to notepad and then here. I'm not sure why it...
November 20, 2019 at 12:53 pm
No problem... Here's the code (below) to build a simple table with 1,000 accounts of 10,000 rows each of constrained random data for a total of 10 million rows. I...
November 20, 2019 at 6:03 am
Viewing 15 posts - 8,296 through 8,310 (of 59,078 total)