Forum Replies Created
Viewing 15 posts - 1,261 through 1,275 (of 13,460 total)
-
RE: Need Troubleshooting help SQL 2008 R2
one of the things i slapped together is a procedure i can call on demand, which grabs whatever is running via sp_whoisactive every 2 seconds, for speedy adhoc monitoring.
it creates...
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 Troubleshooting help SQL 2008 R2
when it happens, can you run sp_whoisactive or at least sp_who2 and see if there is blocking? I'd look to one instance locking a core table, and all the other...
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 substring help
i would do it similar to the way Luis is: remove ALL leading zeros by converting to decimal, and then add as many zeros as needed to make it a...
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: Conferences, immersion events, focused training 2016
in South Florida, most of the SQL related groups are using meetup to organize and publish when there next event is:
this is my local group, for example:
http://www.meetup.com/South-Florida-SQL-Server-User-Group/; Diana Betancourt...
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: Dataviewer is not popping up
i think you have to set the 64bitruntime to false, right? otherwise no debugging/no data viewers?
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: Migrating table from sql server to pdw destination
i think this is an application error, that has nothing to do with the data; might have something to do with permissions, though.
how are you going into pwd destination? could...
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: Monitor table change and email
SQL!$@w$0ME (2/25/2016)
Need to setup alerts to different groups on table insert on different criteria.data on insert is probably going to be an insert trigger on the table itself.
Since database 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: Monitor table change and email
it depends on what you mean by "monitor"
DDL changes; database scoped trigger, or maybe an extended event
data changes: trigger on the table itself, or maybe an extended event
Access(SELECT )...
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: User shouldn't be able to run but can in production
i use this to enumerate all the members that belong to groups that have been granted access from AD:
i've found that some groups cannot be enumerated int he cases where...
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 indexes used in an execution plan?
spaghettidba (2/24/2016)
Actually, I never perform cache analysis in production.I usually dump the whole cache to a table in my local sql server and start from there.
excuse the neophyte question,...
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: Anyone know where I can find example of exe FileZilla from SSIS Exe Process Task?
as far as i know, filezilla, specifically, cannot be called from a command line or automated; it's a GUI tool;
i've used winscp.exe and psftp.exe (putty sftp) with script taskes/command executes;
i...
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: Haunted Spreadsheets: Can't import unless I open & close in excel first.
I've seen something similar, where a csv file was renamed to have an xls extension...so the file was not truely xls, so it could not be opened.
find the original file,...
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 minimice the transaction log file growth during maintenance plain
a maintenance plan tends to use a shot gun approach: rebuild all indexes, regardless of whether they need to be rebuilt or not.
you are probably at that tipping point where...
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: SSIS 2012 to MySQL data load performance
there are a bunch of settings you can do in MySQL to improve the loading of flat files; back when i loaded that huge Ashley Madison dump for fun, i...
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: Creating XML from SQLCMD - with Reserved Characters
Steve i know you can easily get the data with the reserved characters escaped out wiht ampersand amp semicolon, would that be an alternative?
it depends on your data, but this...
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 - 1,261 through 1,275 (of 13,460 total)