Problem with SP1
Since I have installed the Reporting Services SP1, somme reports does not work with the error : The Index and the length must references a place in a string. Parameter name : length Do you know why ? thanks
2004-07-05
tempDB
RE: Alter table name
Not really what I need to do. What is needed is to create a complete set of monthly data with the same table names adding the date to the table name. To rerun a historical report they could rename the tables (3) by removing the data portion.What I was trying to do.Declare @filename char(50)Set @filename […]
2004-06-22
RE: One-step data scrubbing
It will depend on your setup but if you are the default setup for the English version then this should do the trick.SELECT datepart(mm,cast(replace(birth_date,'.','') as smalldatetime))Note: 'dec 12,2004' is understood as 12/12/2004. But 'dec. 12, 2004' will cause an issue. As long as all are the standard abbreviations you should be fine except needing to […]
2004-05-13
RE: Calculating disk space please!!!!
Would check database and LOG file sizes periodically and use the following proc to learn what individual tables are doing i.e, what size each table is using within the data base. A point of caution it is possible that depending upon additions / updates / deletions made to data to have the log file grow faster […]
2004-03-12
RE: Temp Table Name
If you are using local temp tables then SQL Server ensures each name is unique. If you are using global temp tables then you must ensure the names are unique. How are you planning to use the temp tables?
2004-02-19
RE: Temporary tables in stored procedures
From BOL:"A local temporary table created in a stored procedure is dropped automatically when the stored procedure completes. The table can be referenced by any nested stored procedures executed by the stored procedure that created the table. The table cannot be referenced by the process which called the stored procedure that created the table."As for […]
2004-01-15
1 reads
RE: SqlConnection hanging?
I tried adding pooling=false to the connection string BUT I am still experiencing the same problem. Any other suggestions? Thanks!
2004-01-15
RE: Stored Procedure question
Allen's suggestions are the only way. There really is no other method and SQL does not track this.
2004-01-15
NT 4 support, when will it end ?
Does anyone know when Microsoft will end support for NT 4? I heard a while back that end of 2004. We still have 4 SQL Servers running on NT 4 servers and I am really trying to make a case to move them to Windows 2000.
2004-01-13
4 reads
RE: Previous Queries
I'm not sure this answers your question, but if I understand you correctly.... at the bottom of the Active Topics page, there is something like this: Showing page 1 of 12 - 15 of 166 topics. Next 15 Last » Click on the Next and you will go to the next group of postings. -SQLBill
2004-01-08
Blogs
Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
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...
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