Viewing 15 posts - 20,386 through 20,400 (of 59,072 total)
waynes 78578 (6/11/2015)
I find it's a very common problem with accounting tables, which often only store the year...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 11, 2015 at 8:41 am
srgaddam2 (6/10/2015)
I am new to SQL server, so I would appreciate if you could help me understand the SQL hacking concept. What is the purpose of quotename? How can...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 11, 2015 at 8:24 am
snuthalapati (6/10/2015)
Thank you for the reply...How about any auditing kind???
I believe you'd need something 3rd party like Guardium (if I got the name right).
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 9:13 pm
Ok... first of all, that query is susceptible to SQL Injection, which is still the leading cause of successful hack attacks. At the very least, wrap a QUOTENAME around...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 8:08 pm
karen.blake (6/10/2015)
I am getting into this lovely stuff again, when you say table structure what do you need? Column types or how the tables fit together for example?
Hi and welcome...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 7:54 pm
charipg (6/10/2015)
i need to find out the table names which are [font="Arial Black"]modified in last 24hrs[/font].
SELECT * FROM sys.tables WHERE modify_date >= DATEADD(dd,-1,GETDATE());
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 7:47 pm
snuthalapati (6/10/2015)
for ex: we have SSN details in prod, how can mask the sensitive...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 7:27 pm
snuthalapati (6/10/2015)
How to prevent sysadmin user for not to access the data in the database.?
You pretty much can't.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 7:26 pm
snuthalapati (6/10/2015)
how can we track any database performance issues for last week?? (in a particular date/time). Any DMVs?
You might be able to find something left over in the DMVs but...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 5:46 pm
srgaddam2 (6/10/2015)
I need some help in building the dynamic sql . When I create below script and executed the procedure passing the table name and date values its giving...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 5:42 pm
ericpap (6/10/2015)
Jeff Moden (6/10/2015)
ericpap (6/8/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 5:26 pm
Bobby Russell (6/10/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 9:31 am
dniranjan2000 (6/10/2015)
Jeff Moden (6/9/2015)
dniranjan2000 (6/9/2015)
I am new to SQL Server, working as an IT support for the past 7 years and want to move to SQL
I am learning TSQL...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 8:44 am
What is the recovery model of the two servers? Also, what are the growth rates for the database on the new machine? Last but not least, are the...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 8:10 am
madan.preeti2005 (6/10/2015)
No, any start up article will be helpful.
The book at the following link is probably the worlds best on the subject and it's written in such a fashion the...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2015 at 8:07 am
Viewing 15 posts - 20,386 through 20,400 (of 59,072 total)