Forum Replies Created
Viewing 15 posts - 7,291 through 7,305 (of 13,460 total)
-
RE: Way to insert into a table one row at a time??
still easy to do via TSQL;
you can use the row_number() function to partition the data by those 8 columns.
wrap teh results of that with an outer select where rowNumberAlais =...
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: Copy Only restore taking really long time
could your test server be low on disk space? maybe it's taking a long time trying to allocate disk space to the backup before it can ctually do the restore....
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: Way to insert into a table one row at a time??
why not just use a set base operation regardless,and exclude anything that might duplicate? by joining the source to the original table, you can automatically exclude them, or find...
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: delete tables
hodhod26 (6/27/2011)
this data is related to antivirus servers which running from 3 yeares or more we need to delet old data because this size of data make the server so...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: Database compatibility level(s) - log/history
yeah, when i look at powershell at first, i have no idea what it does or what it can 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: Delete with output clause and table aliases
pure syntax issue...the OUTPUT...INTO goes BEFORE the FROM:
Delete t
Output Deleted.TableTID,
Deleted.Value1,
Deleted.Value2
Into...
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: Database compatibility level(s) - log/history
oh lookie: you can do it in powershell as well:
i searched powershell read application log...looks a little easier to do:
# query an event (Filter Equal)
# you could change 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: Database compatibility level(s) - log/history
ok Remi; looks like there is a command line utility called logparser which is designed to read parse/ any kind of log, whether it's iis or windows event logs.
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24659[/B]
so using...
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: Database compatibility level(s) - log/history
well i know EXEC sys.xp_readerrorlog 0 works in 2008, but there's other parameters i'd have to look up;
i would swear you could get teh event/error code int he 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! -
RE: Restrict user from updating n rows at a time
Ninja's_RGR'us (6/27/2011)
Then put that code in a proc and test the front end app to death...Plan A would actually be to fix the application in the first place so that...
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: Printing a column name on the print statement
doh yeah i see how that could happen;
make it two distinct dynamic SQLS:
ELSE
BEGIN
PRINT 'Column does not exist! Starting Work!'
...
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: Restrict user from updating n rows at a time
edit: i'm parroting what Ninja said in a different way...he's too fast!
pujain (6/27/2011)
do you have any other idea to implement this.yes. don't give access to production.
give the develoepr access to...
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: Restrict user from updating n rows at a time
only thing i can think of off the top of my head is a trigger on every table...you could count the rows in the INSERTED/DELETED tables, and compare the ORIGINAL_LOGIN()...
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: delete tables
i have a better question: how do you know, businesswise, you can arbitrarily delete data just because teh table is huge?
wouldn't big tables mean they are busy and in 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: check the version of backup
ew even worse, the results don't have the version you'd expect, that i can see...it has an internal database version, that you need a secret decoder ring to figure out:
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,291 through 7,305 (of 13,460 total)