quote: quote: Was surprised not to see any question about SPN and kerberos authentification. But you only see this in an Active Directory environment. A lot of companies are still NT 4.0. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1 I've got no numbers to backup this statement […]
2003-05-23
2 reads
SQL Profiler and the Index Tuning Wizard. With SQL Profiler, you can capture long running queries to concentrate on first, or you could do a general capture for feeding the Index Tuning Wizard.
2003-05-15
Not the best, but seems to be working. CREATE VIEW Test as Select DateAdd(hh,2,GetDate()) as TheDate GO CREATE FUNCTION TestDate() Returns @TheTable TABLE ([GETDATE] DateTime) as BEGIN Insert @TheTable Select TheDate From Test RETURN END GO CREATE FUNCTION TestDateII() Returns DateTime BEGIN RETURN (Select [GetDate] from dbo.TestDate()) END GO Select dbo.TestDateII() GO Suspect the overhead […]
2003-05-15
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers