RE: Missing PK mark(s)
Probably missing the point as usual, but since Access and SQl Server have different schemas, is not impossible to copy objects(apart from base) between the two.
2003-06-14
career
RE: Error: 1222 Lock request timeout period exceeded
Try un-registering the server in EM and registering it again. You can also change the value for LOCK_TIMEOUT setting. More info. on BOL MW
2003-06-13
1 reads
2003-06-13
RE: query
CREATE TABLE #temp1 (key INT , string VARCHAR(10)) INSERT INTO #temp1 SELECT geoid, CAST(x AS varchar(3)) + ',' + CAST(y AS varchar(3) FROM my_table CREATE TABLE #temp2 (key INT , string VARCHAR(100)) DECLARE @k INT, @temp_string VARCHAR(100) DECLARE c CURSOR FOR SELECT key FROM #temp1 OPEN c FETCH NEXT c INTO @k WHILE @@FETCH_STATUS = […]
2003-06-13
1 reads
2003-06-13
RE: Problems with maintenance job
quote: maybe you have followed my thread about profiler and privacy? At the moment I can't use profiler until I get an answer on this? Not, I don't but I will have a look. quote: But my question was a bit unclear. Do you know if the ADO control utilizes WRITETEXT or 'advises' SQL Server […]
2003-06-13
2003-06-13
1 reads
RE: Error when scheduling a DTS job
May also be that on your machine you have network mappings which is not present in the sql server account. Always use fully qualified names.
2003-06-13
1 reads
RE: PINTABLE
If you mark a table as pinned then it has little or no affect the first time you carry out an operation after it was pinned. It is the 2nd and subsequent time that it works. Pin your table, do a SELECT * FROM your table then do your test. The downside to pinning a […]
2003-06-13
1 reads
RE: Data Referential Integrity - when do you use it?
On this site ages ago there was someone who was running two low grade servers in a profitable dot com and was getting very good performance out of them because the active server didn't have any indices, DRI etc on it. Next day he would make the 2nd machine active whilst the 1st would do […]
2003-06-13
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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