SQL Server 2005 Performance Audit
- by Nai
Do you guys have any good step by step type links for performing an SQL Server 2005 Performance Audit?
Something like this link would be great but for SQL Server 2005.
Search Results
Search found 33316 results on 1333 pages for 'sql team'.
Page 66/1333 | < Previous Page | 62 63 64 65 66 67 68 69 70 71 72 73 | Next Page >
-
-
Changing the Windows authentication users allowed to access SQL Server
- by ladenedge
This seems like a question that should be common enough, but I can't find anything on it. Two questions, really: How can I determine which account(s) have Windows authentication access to an instance of SQL Server 2008? Can I change that set of users without being able to log in to the SQL Server instance? Thanks very much in advance!Read the article
-
SQL Server without Powershell
- by rwallace
I'm trying to install SQL Server 2008 Express Edition, and it's demanding Windows Powershell and refusing to proceed with the installation. Is there any way to get it to install without Powershell? (The reason I'm asking is not so much for myself personally as to reduce the number of headaches through which I'm going to have to drag other people…Read the article
-
Laptop - Capabable of running chunky Sql queries on chunky sql server databases (> 2GB)
- by AJM
I'm looking into a new laptop. It needs to be capabable of running chunky Sql queries on chunky sql server databases ( 2GB). This isn't my usual bag so any advice would be welcome.Read the article
-
Tracking SQL Server 2008 Timeout Errors
- by SDReyes
we got some connections timeouts running a stored procedure in a SQL Server 2008 instance. after a while, the DB started to work as usual, and there weren't any additional timeout errors. So I'm trying to get additional info about the error. Does SQL server 2008 have any kind of error log that I can look into? Do exist any auditing/logging…Read the article
-
Deny login from certain hosts if logging in with specific sql credentials
- by Dave
I want to stop some of our developers from connecting to the production sql server using a specific sql account. They have rights to connect through windows authentication with lower rights. They claim that changing the password will affect too many other processes running on our processing machine. So I want to deny access if they're…Read the article
-
Top queryes in SQL Server 2000
- by Paul
I'm looking for a way to identify top resource consuming queries in SQL Server 2000. Is thre a way to do that other than Sql profiler or a third party monitoring tool like Quest?Read the article
-
Add an Excel file as a linked server in SQL 2012
- by MgSam
I'm trying to add a linked server to an Excel 2010 file from SQL Server 2012. Every reference I've found online for doing this is using older versions of SQL Server, and the driver that they tell you to use 'Microsoft.Jet.OLEDB.4.0', is not present in 2012 from what I can tell. Can anyone tell me which provider I need to use and what…Read the article
-
SQL Server Full Text Search resource consumption
- by Sam Saffron
When SQL Server builds a fulltext index computer resources are consumed (IO/Memory/CPU) Similarly when you perform full text searches, resources are consumed. How can I get a gauge over a 24 hour period of the exact amount of CPU and IO(reads/writes) that fulltext is responsible for, in relation to global SQL Server resource usage.…Read the article
-
Delete data from a SQL Server database on a full partition
- by aleroot
I have a SQL Server 2005 Database on a dedicated partition, during the time the database grown and now it have occupied all the space on the partition, now the problem is that the only operation I can do on the database is detach, but i want to remove old data from some tables to save space ... How can I remove old data from the…Read the article
-
SQL Server Logs: missing date ranges
- by Jeff
I need to be able to export SQL Server logs into CSV files, which I can easily do with the export function. However in doing so I've noticed there's a range of dates missing from the SQL Server logs in Management Studio, two months actually. I'm wondering where these logs might be found, and if it's possible to reload them so I…Read the article
-
Laptop - Capabable of running chunky Sql queries on chunky sql server databases (> 2GB)
- by AJM
I'm looking into a new laptop. It needs to be capabable of running chunky Sql queries on chunky sql server databases ( 2GB). This isn't my usual bag so any advice would be welcome.Read the article
-
Batch vs SQL statement
- by AspOnMyNet
a) A SQL statement is a single SQL command (for example, SELECT * FROM table1 or SET NOCOUNT ON). A batch on the other hand, is a number of SQL statements sent to the server for execution as a whole unit. The statements in the batch are compiled into a single execution plan. Batches are separated by the GO command So the…Read the article
-
Are there any differences between SQL Server and MySQL when it comes to preventing SQL injection?
- by Derek Adair
I am used to developing in PHP/MySQL and have no experience developing with SQL Server. I've skimmed over the PHP MSSQL documentation and it looks similar to MySQLi in some of the methods I read about. For example, with MySQL I utilize the function mysql_real_excape_string(). Is there a similar function with PHP/SQL Server?…Read the article
-
Debugging SQL in PGAdmin3 when sql contains variables
- by Mr Shoubs
In SQL Server I could copy sql code out of an application and paste it into SSMS, declare & assign vars that exist in the sql and run.. yay great debugging scenario. e.g. (please note I am rust and syntax may be incorrect) declare @x as varchar(10) set @x = 'abc' select * from sometable where somefield = @x I want to…Read the article
-
Is it possible to make a MS-SQL Scalar function do this?
- by Hokken
I have a 3rd party application that can call a MS-SQL scalar function to return some summary information from a table. I was able to return the summary values with a table-valued function, but the application won't utilize table-valued functions, so I'm kind of stuck. Here's a sample from the table: trackingNumber, …Read the article
-
Simple solution now to a problem from 8 years ago. Use SQL windowing function
- by Kevin Shyr
Originally posted on: http://geekswithblogs.net/LifeLongTechie/archive/2014/06/10/simple-solution-now-to-a-problem-from-8-years-ago.aspxI remember having this problem 8 years ago. We had to find the top 5 donor per month and send out some awards. The SQL we came up with was clunky and had lots of limitation (can only…Read the article
-
Linked server problem on SQL Server 2005
- by BradyKelly
I have a weird issue and I hope someone can steer me in the right direction for resolving this please. When I execute the following query against a linked server, I get the following error. I can connect to the server in SSMS as a separate server, and execute a similar query against its Deposits table. The nn.nn is…Read the article
-
SQL Server Management Studio not scripting all objects
- by Ian Boyd
i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some. i can provide detailed screen shots the options being selected including all tables the folder where the script files will go the folder being empty before…Read the article
-
SQL Server Management Studio not scripting all objects
- by Ian Boyd
i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some. i can provide detailed screen shots the options being selected including all tables the folder where the script files will go the folder being empty before…Read the article
-
SQL Server 2005 SP3 on Windows 7 - No Management Studio
- by Mike Thomas
I've been trying for a day and a half now to get SQL Server 2005, DEV edition, to work on Windows 7, 64 bit prof. I install from the disk, then run SP 3. I get a failure on the Client Components section of the Installation Progress along with this vague message - Product : Client Components…Read the article
-
MS SQL Server Firewall Ports
- by mmacaulay
Hi, I've recently found myself in the position of quickly deploying a production app on SQL Server 2008 (EXPRESS), and I've been having some issues with configuring firewall rules between our web server running the ASP.NET app and our database server. Everything that I can find on the internet claims that I…Read the article
-
Can't Connect w/ SQL Management Studio After Domain Change
- by Sam
Our old Small Business Server 2003 (acting as our domain controller) was on the fritz, so we replaced it with a new Windows Server 2008 box and set the server up as our new domain controller. In hindsight, it may have been a mistake, but we set up the new server as a replacement and tried to keep as much the…Read the article
-
Orphaned SQL Recordsets/Connections with IIS
- by Damian
I have an IIS 6 site running on Windows 2003 Server x86 with MS SQL2005 Enterprise edition running ASP Classic (no choice). The site runs very fast with about 8000 page views per hour. All of my SQL tables are indexed and I have used the profiler to check my queries, the slowest of which is only about…Read the article
-
SQL Server log backups “stalling”
- by MattK
I have interited a box running SQL Server 2008 and Windows 2003, and have had a few events where largeish (35GB) log backups "stall", both before and after the installation of SQL 2008 SP1. The server log ships to a standby, so regular log backups are taken at 15 minute intervals. However, after an…Read the article
