RE: way to run a query against all dbs?
sp_helpdb will also erturn this, but you have to parse the info.
2004-04-02
Restore
RE: Passing List of Tables
That would alos be a good solution. Since I have a select statement that defines the tables I need to copy, I can pass the list to a table, temp table, sursor, etc. I am mystified about how I get that result set into DTS so it can use it.
2004-04-01
EM does not connect
In the last 3-4 days when I click on the server name in EM I start getting the message:"A connection could not be established to ...server nameReason: Time out expiredPlease, verify that the server is running and check registration properties"I did get the same error from the other machines in the company.I close the message, […]
2004-03-31
RE: DatePart Function
I used this UDF alot to return only the date part. I got from some site. It is also possible to get the time part mathematically. I just forget the URL though!CREATE FUNCTION fn_Date ( @ADate datetime ) RETURNS datetime AS BEGIN declare @DateVal datetime set @DateVal = CAST(FLOOR(CAST(@ADate AS float)) AS datetime) return @DateVal END
2004-03-29
RE: Oracle to SQL Server
Sorry to ask you this question , But can explain what does this statement do? Does it assign the length of the column with blob datatype to amount or something like that? Thanks
2004-03-26
RE: Data placement strategy for a huge database in tera bytes
I've heard a rumor that Microsoft is creating a search engine to compete with google.....
2004-03-25
RE: Single record from Multiple child records via Select statement only
I created a view that returned a record number for each sku within the group then modified your query to be based on this view and it works fine.Thanks for the suggestion =:-)
2004-03-22
RE: Stored procedures are BAD...a philosophical question
I'm regretting not having used stored procedures in my last major project and it has nothing to do with performance. Performance is fine (and I presume in the same ballpark as SPs) by just using parameterized and prepared statements.The reason is just maintanability during optimization. It's very convenient having the code that determines 95% of […]
2004-03-21
RE: Backup Log with truncate_only
Run DBCC SQLPERF(LOGSPACE) before and after the "backup log ...." command to check if it has really been cleared or not. The percentage utilization of the log file for the "db"name should drop down considerably.Hope this helps.AM
2004-03-21
RE: MSDB and Model Database detached
I did exactly what was told in the document, but now reading the document closely it looks like you should not detach model databased and stop SQL. I have copied the files back to their location but still I can't get them up, the server itself does not start
2004-03-17
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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