Forum Replies Created
Viewing 15 posts - 6,391 through 6,405 (of 13,460 total)
-
RE: How to store lots of data (1024 columns) for a particular reading
hybrid of the wide table idea?
do those 1024 columns logically break into groups that could be, say 4 or 5 other tables? (measurement types?)then you have , dunno, 5 tables...
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: how to exclude connections from a computer ?
stop connections permanently, like using the firewall to ignore all traffic from the webserver?
i'd go firewall first, a login trigger would work for an entirely SQL solution, but the hostname...
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: Performance Problem with a Query
yeah i'd consider either dynamic sql as suggested, or breaking this up into 4 procedures.
a master proc that ends up returning one of 4 proc results based on the parameters;
my...
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: DDL Triggers and Permissions
you can grant insert permissions to public for it.dbo.AlterLogin, i *think* that will resolve the audit issue;
i've done the same, but i've been sticking my audit table in master.
USE...
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: Last 5 rows
i'm trying to think this through, does this sound right to everyone?
SQL retrieves the data in what the query engine deems is the fastest way possible, and caches that execution...
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: Stored Procedures - Execute Permissions - proc with dbcc command
Steve Malley (11/16/2011)
I did as you suggested, Lowell, and the freeproccache ran fine. Unfortunately, there was an Db sendmail further on that failed. I would have thought that both these...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: Help with SQL execution speed
The sql plan you posted is returning a query with 247,958 rows? is that right?
an SSRS report should not be presenting a quarter million rows of data for anyone...
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: Add e-mail notification to job via TSQL?
Bryan i think you can simply add a step to your job that would do the notification, and then change the On Failure to call that notification step instead, right?
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: Last 5 rows
Charmer (11/16/2011)
Hi Friends,how do i select last 5 rows without any sorting order?
you cannot.
without an order by, there is no first and last.
SELECT TOP 5 * FROM SOMETABLE will give...
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: Oracle Linked Server query error - unable to read certain data
i see there is a connect item for two other ODBC drivers with the same issue here....
one poster say if he checks this in the settings he gets the error...which...
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: CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS
it's a nice tool, migrates schema and data, but leaves you with the list of items that will need to be converted manually...packages, procedures and functions.
glad to hear you 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: IF versus CASE statements
IF is typically used for logic flow, where CASE is used to return data values;
your example is bending an IF into a situation similar to a CASE, but an...
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: I have a coworker....
Sean Lange (11/15/2011)
...but that is different than 60 seconds. 60 seconds is too much but 30 seconds + 30 seconds is just right.,
yes, but that 10 second pause in 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: Why shouldn't I use dynamic SQL? What is the alternative?!!
well, i would consider creating a view that pulls all 18 tables together...
then the proc can select directly from the view and contine from there.
depedning on what you are doing...
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 shouldn't I use dynamic SQL? What is the alternative?!!
how many values are in dbo.tbl_CDE_MultiMonth, which is where you were gettting the tablenames from?
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 - 6,391 through 6,405 (of 13,460 total)