RE: SQL 2k on WIN 2003
hardwarewise, memory,cpu and IO limits sql server performance. since you upgraded your host, it might push more IO request to your storage, which means now you need to upgrade your storage too.
2004-02-19
data
2004-02-19
RE: Linked Server
If you haven't setup security on your access database the login is admin and the password is blank. Thoses are the defaults for access.
2004-02-16
RE: dynamic sql runs under which user ?
No, dynamic sql is executed with permissions of the current user, even if in stored procedures.Yes, if you need to use dynamic sql, you should use sp_executesql. It allows for parameters and gives you a better chance that SQL Server will reuse query plans.For the sake of completeness, take a look at this one:http://www.sommarskog.se/dynamic_sql.html
2004-01-30
1 reads
Executing Exe files from SQLServer
Does anyone knows how to execute a exe file from SqlServer ( Stored Procedure / Dts / Job ) ?ThanksHM
2004-01-20
3 reads
RE: performance issue with a query
Glad we could help.So you're all set for now?P.S. Heading home for the day
2004-01-08
RE: stored procedure creation error: already an object named xxx in the database
Ok. Paste your script into QA, Run it, get error, click the error and it will tell you which statement is wrong. Post that statement here.
2004-01-08
1 reads
2003-12-05
1 reads
RE: SQL/Active Directory issue???
Maybe this would work: sp_grantlogin [@loginame =] 'login' sp_grantlogin sp_revokelogin Note that the SQL security account procedures and the NT security account procedures differ. If you got a snapshot of all of the logins/role membership/permissions for the NT accounts, and their NT account name has not changed, then you could scan through them and use […]
2003-12-01
RE: Crystal Reports......
The quickest way I have found after about 10 years of using Crystal is to write SQL stored procs (with the advantages of plan caching, ability to use UDFs, etc) and hook Crystal to a single SP that then returns all the data nicely formatted. The less time spent formatting data and joining tables in […]
2003-08-08
2 reads
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers