Most of it is generated in stored procedures. I want to honor other locks that are on the data. But, while those locks from other procs are in place, I want to be able to read the data and be sure not to issue locks...except perhaps on schema. I don't want to issue any new […]
2003-06-06
Well I started out with a create table and insert and moved to a select into. The issue I have with either solution is that I need my data ordered as well as numbered. I used an order by in both scenarios. However in SQL 2000, my understanding is that the order by statement isn't […]
2003-06-06
Firstly you need a unique row identifier for each row add an identity field SELECT * From yourTable WHERE Operating_System = '2000' AND Processor_Speed >=500 AND Location <> 'NOT-KNOWN' Use the sql above to get the rows to satisfy the first aprt of your 'IF' pseudocode and join this back onto the table (self join) […]
2003-06-06
FOr the most part it is only the count you will run into that gives this problem in EM and needs to be updated. But 1) Developers make many more mistakes besides trusting count in EM, make sure they become aware of these things as soon as possible and that they verify the data themselves. […]
2003-06-06
Guess what.. I tried inserting one row to the oracle table from QA, it is taking 7 mts. Is MSDTC service really slow in handling orcle transactions?
2003-06-05
OBJECTPROPERTY ( object_id(tablename), 'IsAnsiNullsOn') DATABASEPROPERTYEX( youedatabase , 'IsAnsiPaddingEnabled' ) DBCC USEROPTIONS
2003-06-05
Crappy, keep on writing reports, explaining the problems, estimates, if not getting your heads of the sand scenario I have warned you, disk full, lost data, cost to resolve. How to resolve and costs. Tell users to speak to the manager. Maybe send report to boss's boss.
2003-06-04
1 reads
I have tried compiling the xp_file but it fails, this may well be bcause I am using VC++, must it be compiled in C only?
2003-05-29
I have similar behavior when I run the debugger from a remote machine. When I logon directly to the machine using terminal services or dameware and then open query analyzer the debugger works. If you remotely login try a direct login and see if that does the trick. -Mark
2003-05-28
1 reads
There are some 3rd party products that let you create pdf's, I think mostly they show up as a printer driver. Try componentsource.com. Doing from Access probably easier than directly from a proc. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-05-23
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers