Forum Replies Created
Viewing 15 posts - 301 through 315 (of 13,460 total)
-
RE: Service Call Log Question
I got it to work as expected by using a SUM(case..) format, with a group by.
My ending date might need to be changed, as i seem to be...
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: View Server State Permission question regarding sp_who2 and security issues/holes
this is a great example of testing it yourself, using EXECUTE AS can let you truly visualize and understand permissions for a user
say mydomain\lowell is the guy you...
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 does your checklist looks like?
Alejandro I have pondered this over time,and there is a difference between informational reports and exception reports for me.
An informational report might have lots of info, names of databases,configuration...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: 70-762 Developing SQL Databases
I've gone through the effort to get some certs,and i will not bore anyone with the alphabet soup.
My feelings are mixed.I'm an experienced DBA. For me,The lower...
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: optimization of stored procedure
your WHERE statements are using functions on a columnName, LIKE statements and OR's, which eliminates the ability to use indexes, so all tables have to be scanned.
you are also...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: DAC connection vs single-user mode
your SQL server could be unresponsive due to high CPU or something, but some memory is always reserved for the Dedicated Admin Connection(assuming it was enabled), so if a server...
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 Database connections for each SSIS package
are the packages using dtsconfig files, or do they all use embedded connection managers?
either way, you can use an SSIS package and some script tasks to scan for...
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 imbed an image into an email sent by dbmail
Karen, Gmail and Thunderbird are both examples of clients suppressing images by default.
https://www.wired.com/2013/12/turn-gmail-auto-image-loading-off/ mentions where they changed the default behavior a while back.
I think they have settings...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 imbed an image into an email sent by dbmail
first, the root of the C: drive, or any drive that has %ProgramFiles% on it is protected, so only users with local admin privilesges can access it.
move your files...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: Ideas on Passing filename from script task to data flow task.
create all your variables you need in your SSIS package.
Pass them to your script task.
then in your code, read them into a variable, assign a value...
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: Send Email From SQL Server Database
gmail has to use port 587 as well as the use_ssl flag.
here's the exact script i use. replace"sqlnotifications@gmail.com" with your gmail address instead.--#################################################################################################
-- BEGIN Mail...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: SSRS ERROR: The definition of this report is not valid or supported by this version of Reporting Services
you'll need to re-save it as a lower version.
with Visual Studio, create a new Reporting services project.
add an existing item with the specific rdl in question.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: split string into two columns
here you go, here is one way:
i just used a case statement to examine the fifth character, to determine where to start the substring:/*
ActualValue ExpectLeftValue ...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: Equivalent to Generate Scripts in TSQL?
Beating my own drum here, but i put together a procedure that queries the metadata to script tables and objects:
I try to maintain it as best I can, it'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: How to roll up quantities > 1?
your example was not syntactically correct, i fixed it for you.
the key you want here is to group by and SUM.
some things just don't belong in the results,...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 - 301 through 315 (of 13,460 total)