RE: xml: text or ntext
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-07-18
Tally Table
RE: Complex Query -- Help needed
I fixed the error and the CASE way works great! Thanks alot to everyone who replied. I learned alot more about how to create these complex queries. I appreciate all your help!
2003-07-17
RE: Independize DTS from the enviroment
We use Global Variables along with a case statement to change the Server and Database information in production. The following code is put into a ActiveX script that is the first task to run: Select Case DTSGlobalVariables("Environment").Value Case "Development" DTSGlobalVariables("Server").Value = "Server1" DTSGlobalVariables("Database").Value = "Database2" Case "Production" DTSGlobalVariables("Server").Value = "Server2" DTSGlobalVariables("Database").Value = "Database2 Case Else […]
2003-07-16
1 reads
2003-07-16
1 reads
RE: data modification
Yes, though I don't know of many who would recommend it. For SQL 2000 (don't remember if this worked in 7.0): In EM, right click on a table in the database in question, select Open Table, return all rows. Pops up an editable grid. SJTerrill
2003-07-15
RE: TempDB
TEMPDB can fill up and lock users/queries if you don't have it set to automatically grow enough. Notice I said 'enough'. The growth size has to be enough that it can grow faster than the space is filled up. For example, lets say you set it to auto grow by 100 MB. You get a […]
2003-07-02
RE: Best practice when to use an index
Jeremy - quote: unless the execution plan is wrong It often is, luckily for us.
2003-06-24
1 reads
RE: Server slow down after stopping replication
Hi all, I have experienced a similar slowdown in EM performance. Removed replication from our server and the database is performing fine for our users, but not while trying to perform basic actions via EM, example opening a restore db window can take several minutes. Any ideas would be appreciated. Thanks, Robert
2003-06-13
RE: Orphaned logins in SQL 2000?
Look at sp_change_users_login, you can fix much easier this way and is the same for 7 and 2000.
2003-05-06
Blogs
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Goal Progress for Jan 2023
By Steve Jones
The grade for January is a D. Details below, but just not making a...
Context Info Across Databases–#SQLNewBlogger
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
Forums
Storing a text file in a VARCHAR(MAX) column
I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...
"ID" primary key from two separate tables as a foreign key in a new table
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...
blocking issue
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...
Ask SSC