Forum Replies Created
Viewing 15 posts - 9,421 through 9,435 (of 13,460 total)
-
RE: select top 2000 from table_name cause tempdb full
you've got to look at the execution plan to be sure...
a simple SELECT TOP 2000 FROM SOMETABLE would probably not bloat temp db, but throw in an ORDER BY, and...
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: Pricing EDI Feed Processing System
I currently maintain a system that does EDI 864 records;(?? didn't really notice they are numbered)
if you have the schema and sample EDI file, I could look to see if...
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: SQL Server 2005 training
I've been in touch with some of the guys at a SQLServerCentral related site http://www.sqlshare.com/ to build on skills i do not get to use every day.
I met a few...
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: Table hierachy using sql query
this caught my eye, i've done a lot of stuff with following foreign key chains;
how would you expect the table T2 to be displayed? it has two children inder it...would...
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: Create a sql login with access to all the databases
just like sa and Builtin\Administrators, and login you create that is part of the sysadmin will inherit the ability to do anything to any database.
CREATE LOGIN [superman] WITH PASSWORD=N'NotARealPassword',
DEFAULT_DATABASE=[master],...
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: Value dependent User Key
it looks to me that although logically the unique key is just two columns, in actuality for db purposes, shouldn't it include the deleted column as well?
Field1 ...
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: List of Tables Used in an Query
rvasanth
If this is more for documentational purposes, and not something you are trying to run live for every query, I think i have a potential solution. As already...
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: SQL query help - with AS <column_name> truncating results
it's not truncating the data, jsut the display of it;
change this setting in SSMS: it's Under Tools>>Options; the default is to limit the results to 256 characters, like you've identified.
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: Problem with a Query
ok, still easy to do...can we assume the query results will be seen in text mode?
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: Ask multi login sql
yes, if you have a valid username/password, you can connect multiple times.
different people can connect from other computers using the same username and password as well.
there is no practical limit...
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: Problem with a Query
i feel for you;
i did a search for "ascii art hearts" and found lots of examples;
i found this nice one ad wrapped it with the SELECT...UNION ALL, same that your...
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: Procedure for Removing Obsolete SQL Objects from Production Environments
I've got a snippet I put together that searches for invalid views/procs/functions; if those objects don't compile anymore, it has to be due to a dependent object like a table...
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: Procedure for Removing Obsolete SQL Objects from Production Environments
a fairly common question, actually; search for "unused procedures" and "unused tables", you'll see a ton of discussions, all pointing to Lutz's conclusion: any process, whether a trace or anything...
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: The function takes forever to run for 13,000 data
damn Lutz; your's looks much better than mine, so i decline to post it 🙂
very nice job.
blade, if you look at Lutz's contribution, it's doing all your updates as calculations...no...
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: The function takes forever to run for 13,000 data
table variables are notoriously slow when they get a lot of data in them, because they cannot take advantage of statistics; how many rows are in the table variable @LENNOXBILLING?...
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 - 9,421 through 9,435 (of 13,460 total)