When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct? Why do you change varchar to char if varchar is larger than 5?
2004-02-13
2004-02-12
1 reads
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
2004-02-10
In this case I would suggest to you to reindex and/or update the statistics.You could also check how many rows you have for 01/01/04 and how many for 02/04/04
2004-02-09
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!
2004-02-06
Sorry, no harm meant! More of a little after work joking, as here in my place it is already 9 PM.
2004-02-05
I would have done it this way just to cut down on typing - select left(datename(month,getdate()),3) + right(datepart(year,getdate()),2) . Does anyone know which performs better? my execution plan tests prove inconclusive.
2004-02-05
Database Administrators should also be invloved in the development of organisational standards for software development. In my organisation we have a document that details the programming standards, and this includes standards for accessing databases. Code reviews help ensure that developers adhere to these standards.We also have a library which all end-user input is passed through […]
2004-02-03
Neddy,You state: Another table is inserting into the table with Status_Date bya triggerCheck out the trigger, it might be the cause of your problem.-SQLBill
2004-02-03
1 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
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...
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