Forum Replies Created
Viewing 15 posts - 7,171 through 7,185 (of 13,460 total)
-
RE: Application is unable to connect to the database.
is the new 2008 server an express version? is it a defaul instance or a named instance?
have you been able to connect to it before?
have you eliminated any networking issues...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: export all table to excel with header using bcp
the error's pretty clear. the temp table you are inserting into doesn't match your select *.
either create a table explicitly for your select *, or you have to identify the...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Query suddenly taking minutes rather than seconds
what a great job posting everything we might need; thank you for the actual execution plan!
i see a few places where the statistics are a little off; usually an order...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: 64 bit client, xp server -- No go
also express editions don't accept allow remote connections by default; you'll need to right click on the server in SSMS, go to Properties,a nd then Connections:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Need help optimizing the performance of a query
is there a clustered index, maybe on customer_id? can you give us the actual CREATE TABLE definition so we don't have to guess?
the actual execution plan, saved as a .sqlplan...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Indexing for Group By Clause
post the actual execution plan you looked at and let us peer review it with you;
trying to guess at performance from pseudo code won't get much other than guesses.
what are...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Need help optimizing the performance of a query
i ran the provided data thru my data formatting macro so we can have sample definitions, but we are still waiting for indexes and actual execution plan, which will tell...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Invalid Object In SQL Server 2008 database
form some article i wrote: this is just one way to do it, there are other techniques as well, ig you search SSC, there was another recent thread on the...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: What is considered an acceptable variance in query response?
on the dbserver, are there any other services going on in it is it doing Exchange as well as SQL, or web hosting?
does the server also host, say, the company's...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: A type of string search.
if you look at edmunds.com, they have a typical search fro autos/old and new; i would avoid allowinging raw text/data entry for fields if possible; much easier to use predefined...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: A type of string search.
i've always done this with the user interface/web page building a dynamic SQL;
something like this (assuming all data entry comes from drop down lists, and vb.net as far as syntax:
...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: SMS Maint Plan is Not Smart Enough To Know When A Database Is Deleted When It Runs
you'll need to edit or rebuild your plan, i think.
I just created a new main plan, and when i look a tthe details, depending on how you set it up...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Why Index Scan instead of Index Seek
kramaswamy (7/11/2011)
I'm curious, why is it that using UNION instead of OR makes for performance increases? For most situations like this, the query optimiser is usually smart enough to do...Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: String to Paragraph.
this seems to work for me:
SELECT
SUBSTRING(text150,1,60) AS text60_1,
SUBSTRING(text150,61,60) AS text60_2,
SUBSTRING(text150,121,60) AS text60_3
FROM YourTable
SELECT
SUBSTRING(text150,1,60) AS text60_1,
SUBSTRING(text150,61,60) AS text60_2,
SUBSTRING(text150,121,60) AS text60_3
FROM (SELECT 'EG
SABRE a CIRCUIT BREAKER...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Why Index Scan instead of Index Seek
I'm pretty sure it's the OR.
with a single value, it can do a SEEK, but with the OR, it has to scan to check the values that don't match the...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 7,171 through 7,185 (of 13,460 total)