Viewing 15 posts - 2,446 through 2,460 (of 49,552 total)
mw112009 (9/8/2016)
The code for a SP goes in this table. Similarly how can we get the DEFINITION of a view
select [definition] AS ProcDef from sys.sql_modules
Exactly the same way....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2016 at 1:20 pm
What do you need help with? What's the code doing or not doing that it shouldn't?
And I will reiterate my comment from last time this came up
GilaMonster (6/10/2016)
Chitown (6/9/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2016 at 8:43 am
djj (9/8/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2016 at 8:40 am
Grant Fritchey (9/8/2016)
GilaMonster (9/8/2016)
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2016 at 8:36 am
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2016 at 6:08 am
There's no way to pass parameters to a view. Either the users apply the date filter when they query the view, or you'll need to change to a procedure or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2016 at 1:09 am
http://source.entelect.co.za/why-is-this-upsert-code-broken
While it talks about insert/update pairs, your manual sequence code will have the same problems.
Edit: And if you need an incrementing value that starts at 5,
SomeNumber INT IDENTITY (5,1)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2016 at 1:00 am
If you've analysed and tested, and have confirmed through careful testing and consideration of alternatives, that the hint is the best way to solve the specific problem you have (most...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 7, 2016 at 6:15 am
Same way you shrink any other database. DBCC ShrinkFile ('File name', Target Size)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2016 at 2:39 pm
No.
You could bcp every table out to flat file, script the structures and recreate the DB, but that's a huge amount of work.
What are you trying to achieve here, and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2016 at 9:13 am
Speak to your SAN admin, storage admin or whoever is responsible for the storage on that server. If the files aren't accessible, then that will have to be fixed before...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2016 at 6:43 am
Gregory Hart (9/6/2016)
if divide by zero is allowed, it's possible to prove that 1=2
The above claim would only work in a logical proof if you identified that NULL= NULL ....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2016 at 6:40 am
Not asking if you can see the properties of the database in SQL. with the errors mentioned it's obvious you can't.
Can you see the database files in the file system?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2016 at 4:19 am
Wow, you got a 'thanks'. Impressive.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2016 at 4:17 am
I second the recommendation for an audit table.
That said, there's no stored procedure that I know of to run alter table syntax on multiple tables, you have to run it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2016 at 3:03 am
Viewing 15 posts - 2,446 through 2,460 (of 49,552 total)