2005-02-24
1 reads
SQL Source Control
RE: How to ensure order is kept in import from csv
Yes, the clustered index will ensure that the rows are physically ordered based on the columns you specify in the index. Some things to bear in mind: You can only have one clustered index per table (since it is determining the row order, it would not make sense that you can have more than one). […]
2004-03-18
Trying Shrinking, backup log , sp_force_shrink_log and nothing...
Hello people, I've a problem trying shrink the log files from 3 database. I tryied backup full, backup log ,truncate log , shrink , sp_force_shrink_log and nothing.I think that the problem is the logical name for the files, because is the same....like this... 3 databases.dbmatrix , db2 and db3 but the 3 db's came from […]
2004-02-11
19 reads
RE: Temp Tables in SQL Server
I have found that table variables have their limitations. In a datawarehouse environment, with query results totaling hundreds of thousands of rows, or more, table variables are NOT the way to go. Temp tables work much better.But.... thank you very much for the rest of the article.
2004-02-11
1 reads
RE: EASY Quation
The problem is the way your flagging mechanism works you have time for new records to enter without being seen. I suggest using a 3 value flag. Like so UPDATE MYAccess...Answers SET MARK=2 WHERE MARK=0 INSERT INTO t_mazz_sms_esf (caller_mobile_num, call_time, sms_body, sms_type, original_sms, operator_id, lang, status, voting_flag) SELECT Jawwal, [Date], Answer, 0, Answer, 10, Langaue, 0, […]
2004-02-11
RE: Conflicting server versions
I spoke with NGSSoftware about this also and we never could conclusively figure it completely out. sorry Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-18
RE: Where Do I Want To Go Today? - From the Field
Not sure I like the trigger idea either. Though you have to weigh the overhead of cursoring through the rows in the logical tables vs just firing the trigger once per row - how much different could it be? I can see where it would save writing a lot of repetitive code. I'd support it […]
2003-09-02
2003-08-25
RE: Query analyser fails when execution plan shown
>>Installed XML on both server and locally? Not exactly sure what's installed on the server(s) in terms of XML, but I get exactly the same results when I connect to the local SQL Server instance, as when I connect to a remote server. To reproduce it, I just need to run SELECT 1 example FOR […]
2003-08-20
1 reads
RE: Why does the Transaction Log keep growing?
Another reason this can happen is if you're running transactional replication and the log reader isn't running. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-08-16
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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