Forgive me for this (my mood management today has failed), but you might suggest your boss to post to Microsoft SQL Server newsgroups. With a little bit of luck Joe Celko will respond. Would he be reputable enough? If so, be prepared for an offending reply. Even if you go up on several hundreds of […]
2004-01-14
1 reads
Have a look at Frank's reference at http://qa.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15691&FORUM_ID=9&CAT_ID=1&Topic_Title=ntext+confusion&Forum_Title=General
2003-08-28
1 reads
I found : Schema Changes on Publication Databases Schema changes can be replicated during snapshot replication, transactional replication, and merge replication. Column additions and deletions are implemented at the table level and propagated to all Subscribers that receive data from that table. For snapshot replication, the schema change is propagated when a new snapshot is […]
2003-07-03
First off based on quote: UserDate (userId, latestDate) should this line quote: join UserDate D on D.userId = A.userId and D.date = A.date actually be join UserDate D on D.userId = A.userId and D.latestDate = A.date and if so then why not just do SELECT I.* FROM UserActivity A INNER JOIN UserImpression I ON A.userId= […]
2003-06-25
One thing we found was that the disk that the data files are on is extremely fragmented (data area - > 90%, free space - 5%) Can this cause the problems with accessing the #tables? We didnt' notice any slow down accessing regular table, only #tables.
2003-06-06
Did you look at BOL? There are a couple of items to check there. 1) Under "Managing DTS Package Programs" there is a section at the bottom titled "Saving and Loading Packages" that looked plausible and probably a bit like your technet advice. 2) There also appears to be a method you might employ, LoadFromSQLServer. […]
2003-06-06
1 reads
Hi Crispin, quote: Just completed it. Not sure what I got myself into. Maybe now I will be getting emails asking if I am lonely... Short survery and useless if you ask me. I already receive those mails asking if I wanna be friend to ???. Short surveys I like best. I only did this […]
2003-06-04
1 reads
Here is an easier procedure I found in technet: Step 5: How to Move DTS Packages Step 5 is optional. If DTS packages are stored on the source server in the SQL Server or the repository, you can move them if you want. To move DTS packages between servers: Save the DTS package on the […]
2003-06-03
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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