RE: Agent Job won't run - HELP!
It sounds like a permission. Run it directly from server fail proves that. Server might not have right back to local poxpro table.
2004-01-01
1 reads
APPLY
RE: Resizing tables and rows to better fit into pages
You may want to run DBCC SHOWCONTIG () WITH TABLERESULTS It will Answer most of your questions!
2003-12-30
1 reads
RE: using IN and a list of values
Wow! Thanks. I'm always impressed when people take all that time to help others. Have a wonderful day mia !
2003-12-04
RE: If PK is a GUID, what index type is best?
I think that having a GUID as a PK is an acceptable (didn't mention preferred) practice. Having it then clustered seems to make no sense whatsoever. I highly doubt that there are very many tables of GUID's that would have range queries ran against the GUIDs. (I'm sure there might be a few, but doubt […]
2003-07-10
1 reads
RE: If PK is a GUID, what index type is best?
Hi, This is slightly off topic but why is using a GUID for a PK considered bad practice? We use replication so GUID's as PK's (not clustered) are the way to go but I wouldn't have thought they had a particular downside. Is it because they a bigger that an identity column? Cheers, Peter
2003-07-10
1 reads
RE: Select 2 lines into 1
As alphaindex pointed out, INSERT creates a new row each time. You can solve it via alphaindex's solution or change your second INSERT to an UPDATE. INSERT to create the row with part of the data and then UPDATE it with the rest of the data. -SQLBill
2003-07-09
1 reads
RE: Problem Inserting with Multiple Joins
But if ran the select without the insert which table would I select from? All 4 Site, Tier, Ip_Address & Lan? They are all populated except the Router table which is empty. We're trying to write SP's to handle inserts into the Router table.
2003-06-11
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers