2004-04-28
script
RE: Question of the Day for 05 Feb 2004
The kidz at SQLServerCentral.com are noticably silent so far....
2004-02-08
RE: how to find sa password from registry in sql 2000/7.0/6.5 if i forget the sa password?
Or get a white marker pen !
2004-01-16
3 reads
RE: How to TEST if statistics should be updated.
I have would have an another approach. For me in a small db of 80 MB a query of 30 sec or even minutes is inimaginable. Something must be wrong out there. Therefore did you check in the profiler if you are using the indexes correctly or it is making a table scan? Do you […]
2003-12-30
RE: QOD 12/17/03
there is much more than Points that i earned by answering the question that in future i can think this thing in my mind that i am always not wrong in answering the questions sometimes question is also wrong Feeling more confident !!!
2003-12-17
1 reads
RE: QOD 11/25
I never look up first, I treat these questions as test questions to find out how much I do know to prepare myself for the exam. quote: I always answer without researching. Except for today. And if 60-something percent of respondents got this one right, it means they went and looked it up. (I look […]
2003-12-09
RE: SQL XML mapping
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-12-08
RE: Index for column with a lot of Null
---------------------------------- quote: Creating a composite index will not work in my situation. This is becuase those three columns are in the Where clause of three different SPs. -------------------------------------- I still don't see why you wouldn't use a composite index. As long as the first column is referenced in the query then the index will be […]
2003-08-27
RE: Index for column with a lot of Null
Yes, this is a very highly transactional table. There are about 10 processes querying and updating this table every other seconds...
2003-08-27
RE: Help with query
What is it with concatenation! Not too sure where your heading with this: Rec_ID Value Concatened_Value 1 first_value 'str1 str2' 2 second_value 'str3 str4 str5' What exactly are you trying to acheive? If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the […]
2003-08-15
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