RE: Connect to Aliased Cluster Named Instance
having the same issue It will work for the default instance, but not for the others.
2004-02-25
Indexing
rebuild master failed with error -1
Anyone knows how to solve and cause for this error, it is coming while rebuilding master database.--sntiwary
2004-02-24
11 reads
Password validation failed
Hello Everyone,I just installed SQL Server Yukon. I tried, via the new SQL Server Workbench to create a SQL Server login but I received this error:TITLE: Sql Workbench ----------------------------------------An exception occurred while executing a SQL statement : Batch or statement execution failure : Password validation failed. The password does not meet policy requirements because it […]
2004-02-23
15,004 reads
RE: Timeout Expired to early ASP.net
Have you verified the database connection to make sure that the DB server is responding?
2004-02-20
RE: Removing IDENTITY Constraint
Please avoid double postings. Let's continue here http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=101113
2004-02-19
RE: Need Help with Crosstab Pivot Table Query
The table is named "Rate" with 3 fields: 1) From_City varchar(50) 2) To_City varchar(50) 3) Cost intIt's a simple table, but is giving me a very big headache... If you need more info, just let me know.
2004-02-17
How does SQL Server divide up CPU
We have a performance problem on our servers and we have isolated it down to one particular application. However, the question asked in meetings is how does SQL Server divvy up CPU between SPIDs? For example, between 10:32:36am and 10:48:02am, the server's CPU was maxed out by the service sqlservr.exe. Looking in Enterprise Manager at […]
2004-02-17
5 reads
Forcing order of evaluation
I recognize that a where clause with something like "WHERE A=B and C=D" you might not be able to count whether or not it will evaulate the "C=D" if A<>B.But there are times you need to and I thought it was possible by doing nested selects. But it isn't working. Here is a real example:select * […]
2004-02-16
5 reads
RE: How to convert vertical records to horizontal?
Frank,Don't be so quick to give up on the data layer. I had a similar challenge... I've posted ALL the code including the example data and table creation. The actual code that does the work you are looking for is very short. If you don't need the delimiter, set the delimiter to '' and you'll […]
2004-02-16
8-way Xeon PIII 700mhz vs. Dual Xeon P4 3.0ghz
When running a web-based eCommerce system using SQL Server 2000 Enterprise, which platform would you choose from the following 2 choices:a) 8-way Xeon PIII 700mhz (2mb L2 cache) with 16 gb SDRAM (this is a Netfinity 8500r -> 8 CPUs)b) Dual Xeon P4 3.0ghz (not MPs) (512kb L2 cache) with 4 gb DDR SDRAM (generic -> 2 CPUs)Assume […]
2004-02-13
6 reads
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