Viewing 15 posts - 1,786 through 1,800 (of 7,164 total)
No problem. One tweak for clarity. My query should have qualified the table with the new name of master, not master again:
SELECT *
FROM new_name_of_master.sys.configurations
WHERE ...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 3:26 pm
Never tried it, but you could restore a backup of master with a different name to a running instance and issue:
SELECT *
FROM master.sys.configurations
WHERE name...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 3:08 pm
scogeb (3/1/2013)
You can also do server\instance,portlike
SQL01\TestInst,55001
Depending on the driver the instance name can take precedence over the port, or vice-versa. It is not consistent across drivers. I would recommend against...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 1:34 pm
GilaMonster (3/1/2013)
Or a TOP 1 (without specifying WITH TIES) where the column you're ordering by has duplicate values
Nice. That is a tricky example that might slip by even a good...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 11:54 am
After uninstalling the 2005 default instance you can simply change the port on which the 2008 R2 instance listens to 1433 and it will begin appearing on the network as...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 11:47 am
@Gail, In thinking about this a little more, I think the example I gave is just a roundabout way of asking for TOP 1 without an ORDER BY, which I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 11:31 am
Found one. I was never under the impression that adding or changing an index was completely harmless for various other reasons but not for this particular one. I am still...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 11:18 am
I realized that nuance after I posted.
Looking to mock-up an example...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 10:47 am
GilaMonster (3/1/2013)
opc.three (3/1/2013)
My comment was that the yield from the FROM, WHERE, GROUP BY and HAVING clauses is not altered based on which index the engine picks.
I can probably produce...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 10:40 am
Sounds like a bug in SMO.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 10:04 am
sqldba_newbie (3/1/2013)
Jeff Moden (3/1/2013)
opc.three (3/1/2013)
Jeff Moden (3/1/2013)
Actually, the change of an index CAN very much change the result especially where UPDATEs are concerned.
I think we covered the OP's question about...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 10:03 am
What times were they started? Does it look random or like a scheduled job? i.e. on the minute or hour every time? I might start asking around. Maybe someone logged...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 10:01 am
Jeff Moden (3/1/2013)
opc.three (3/1/2013)
Jeff Moden (3/1/2013)
Actually, the change of an index CAN very much change the result especially where UPDATEs are concerned.
I think we covered the OP's question about SELECT...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 9:47 am
I am concerned that you are asking for help with such a critical item on a free public forum on behalf of a client. If I were you, and you...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 8:23 am
What does your logging say when run through SQL Server as compared to when it runs successfully through SSDT?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 1, 2013 at 8:13 am
Viewing 15 posts - 1,786 through 1,800 (of 7,164 total)