Is it a good to write a store procedure using dynamic sql? What in ways could I optimize this SP that uses dynamic sql? The tables will contain several million rows and I need to return only 20 rows at a time. Help? It seems to be working fine and fast but everyone tells me […]
2004-02-10
2 reads
How large your log backup typically from 9PM to 9AM without performing database shrinking?DBCC SHRINKDATABASE moves the data and index pages within the database files and such activites should be logged for recovery purpose.
2004-01-08
Hey biker,your avatar is also kinda cool! Although I prefer a Fireblade Now, for the pseudo topic relation:I think Andy Warren mentioned some time ago, he has some SQL Server table maps to share.
2004-01-07
1 reads
Äh, now I'm really confused! I still believe my post was not targeted to the original question. Did we find a solution or not? Frank http://www.insidesql.de http://www.familienzirkus.de
2004-01-03
1 reads
unfortunately, the db is in another state, and administered by a dba there; I was trying to diagnose issues by remote; both Auto Update Statistics and Auto create Statistics are turned on in the restored version of this database, by looking at the Properties>>Options in EM after I restored a backup from the client. Supposedly […]
2003-12-29
NO, it's actually being started under the domain Administrator's login.
2003-12-11
2 reads
quote: I've done it once. I dind't found any problems. It will al depend of how much transactions you will deliver each time you connect. When I did it, I create a batch file with the rasdial command, to connect with my phone line, once connected it fired the distribution job of my transactional replication. […]
2003-11-28
Wait!! I read your message again. I'm guessing you are logging in with a user account that has a default database that it doesn't have access in. Check and see what the default database is for the login you are using, then check and see if that account has access (is a user in)to that […]
2003-11-25
2 reads
2003-11-14
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-09-01
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
By James Serra
A TON of new features announcements at the European Microsoft Fabric Community Conference help...
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